(COUNT(CASE WHEN KPI("VALUE_PAY") <'0' THEN 1 ELSE 0 END))/(COUNT(CASE WHEN KPI("VALUE_PAY") >'0' THEN 1 ELSE 0 END))
Page 1 / 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.