(COUNT(CASE WHEN KPI("VALUE_PAY") <'0' THEN 1 ELSE 0 END))/(COUNT(CASE WHEN KPI("VALUE_PAY") >'0' THEN 1 ELSE 0 END))
Question
I need some help again :(I need to calculate % (the outstanding payments divided by the payments made) i.e. the formula would be:
+1+1But, i can't and i dont know why!
If payments is your case, try "THEN CASE_TABLE()._CASEKEY ELSE NULL END" instead of "THEN 1 ELSE 0 END" in the first term (before the division sign, don't know the name in english)
Depending on your process model, you can try it also in the second term.
Also, in certain cases you could need add a GLOBAL() encompassing the second term
HTH
Login to the community
No account yet? Create an account
Login with SSO
Celonaut Login Celonis ID LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.