Skip to main content
Question

I need some help again :(I need to calculate % (the outstanding payments divided by the payments made) i.e. the formula would be:


ariane.reis
Level 3
Forum|alt.badge.img+1

(COUNT(CASE WHEN KPI("VALUE_PAY") <'0' THEN 1 ELSE 0 END))/(COUNT(CASE WHEN KPI("VALUE_PAY") >'0' THEN 1 ELSE 0 END))

ariane.reis
Level 3
Forum|alt.badge.img+1

But, 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


Reply