Deviding KPI1 / KPI2 does not work. Why?

Hello everybody,

I have a problem, which is definitely easy to solve, but I lack the idea.

I have a KPI 1:

COUNT (DISTINCT CASE WHEN “EBAN”. “LOEKZ” = ‘X’ THEN “EBAN”. “BANFN” ELSE NULL END)

I have a KPI 2:

COUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [‘Technical Clarification’]) = 1 THEN “EBAN”. “BANFN” ELSE NULL END)

I would like to divide KPI 2 / KPI 1 in a new KPI 3.

The new formula…

COUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [‘Technical Clarification’]) = 1 THEN “EBAN”. “BANFN” ELSE NULL END)
/
COUNT (DISTINCT CASE WHEN “EBAN”. “LOEKZ” = ‘X’ THEN “EBAN”. “BANFN” ELSE NULL END)

unfortunately does not work that way.

Can anyone help why?

Thanks a lot

What does not work? Do you get an exception? Or an unexpected result? Or??? I would need a bit more information to help you out.

Sry, we speak from an wrong result, not an error.

#technical-implementation

I hope this picture helps.

Hi Steven,

First of all I would set the formatting not to .10% but to decimal.

Second, I believe 10268 / 78 = 131.64

Please let me know if this fixes stuff.

I’m sorry.
yesterday was not my day.

I mean of course KPI 2 : KP1, so 78 : 10.268

But the formula order is correct.

With the .10% I just wanted to make it clear that my result is 0.

0 as a result is wrong.

Sorry for beeing persistent but could you change the formatting to decimal?
image

I find that incorrect formatting strings might mess up the output. Once we get the PQL working, you can tweak the formatting all you like :wink: