% take the wrong data base

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 ?

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:

COUNT(CASE WHEN "EKKO"."BSART" IN ('NB') THEN "EKPO"."_CASE_KEY" ELSE NULL END) /
COUNT("EKPO"."_CASE_KEY")

Best,
Viana

Hi Viana,

That doen’t work.
image

But i’m sure that I’ve data in my EKKO.BSART.