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:

  • June 5, 2023
  • 2 replies
  • 0 views
A
  • Anonymous

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

2 replies

A
  • Anonymous
  • June 5, 2023

But, i can't and i dont know why!

A
  • Anonymous
  • June 5, 2023

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

Terms & ConditionsAccessibility statement