Calculated key figure based on OR condition

[Former Member]

Hi All,

I would like to apply OR condition on two calculated keyfigures. IF CKF1 > 0 or CKF2 > 0, then record should display in report. Would you please suggest me on best of achieving it.

Regards,

Jo

[kohesco · Accepted solution]

hi

new formula = ( CKF1 > 0 ) + ( CKF2 > 0 )

condition on new formula-> new formula >=1

[Loed]

Hi,

You may do this..Create a CKF with the formula below..

FINAL_CKF = ( CKF1 > 0 ) * YOUR_KF_RESULT + ( ( CKF2 > 0 ) * YOUR_KF_RESULT )

Regards,

Loed