Skip to main content
Question

Count vendors with one order

  • May 4, 2020
  • 1 reply
  • 1 view
D
Level 0

Hello everyone,

I want to analyze how many vendors were just created for one order.

What did work?

I created an OLAP table with vendors and a simple case count.

What is not working?

I am not able to count the number of vendors with one case. So, I would like to have a KPI Number of One-Time-Vendors and it should show for example 150.

Can anyone help me with this issue? It should be basically equivalent to an Excel countif.

Thanks in advance.

Best regards,

David

1 reply

D
Level 5

Hi David,

maybe you can try this solution?

COUNT(CASE WHEN LEFT(PU_COUNT(LFA1, EKPO.EBELN)||XXX||LFA1.LIFNR,4)=1XXX

THEN LFA1.LIFNR ELSE NULL END)

Combine the number of cases with || XXX and || the vendor number. XXX is to seperate the number of cases from the vendor number

Community Code of ConductAccessibility statement