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

Page 1 / 1

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.
image1452881 76.5 KB #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

image612627 79.2 KB

Please let me know if this fixes stuff.

Im 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?

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

Sign up