Using of an OR or XOR

[Former Member]

Hi experts,

I need to use a calculated KF with an 'Operand1 OR Operand2' but I also need the overall result and here come's the trouble: the total result is still 1 but when you drill down the number of orders you discover that are 5!

I tried to use COUNT( operand1 + operand2) but the overall result it's still the same : 1!!

Have you got any idea for solving this problem? I will reward every tip with points.

thanks a lot

Best regards

Fil

[Former Member · Accepted solution]

the overall result of boolean operation, in your case OR, will be 1 (true) or 0 (false), try to force the overall result as sum in your formula/key figure properties

[Former Member]

Hi,

Have you made the tick in the CKF propeties "Also apply to results"

[Former Member]

Hi

It doesn't work: the result is still 1.

thanks

regards

Fil