Hi,
I would like to understand, which data base that Celonis used to calcul is ratio.
I have 3 406 PO with a PO Doc. type (ZNS, ZNB or ZST) I would like to see the % of each PO Doc type.
I had use this formula : KPI(Ratio, EKKO.BSART = ZST)
The result is 14.67%, while I should see 37.70%.
I create a OLAP table, if I put the same formula but add a Case Count Column, the result is good. If I retired the Case Count column the result is wrong.
Whats happened ?
SHould I add a case count in my ratio formula ?
Page 1 / 1
Hello Audrey,
most likely, the KPI is calculating on an EKKO level and not on an EKPO level as preferred. This is why there are differences with respect to the results. What you could do is apply this formula instead to see the correct KPI:
Best,
Viana
most likely, the KPI is calculating on an EKKO level and not on an EKPO level as preferred. This is why there are differences with respect to the results. What you could do is apply this formula instead to see the correct KPI:
COUNT(CASE WHEN "EKKO"."BSART" IN ('NB') THEN "EKPO"."_CASE_KEY" ELSE NULL END) /
COUNT("EKPO"."_CASE_KEY")
Best,
Viana
Hi Viana,
That doent work.
But im sure that Ive data in my EKKO.BSART.
That doent work.
But im sure that Ive data in my EKKO.BSART.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.