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 ?