Skip to Content
avatar image
Former Member

Calculated key figure based on OR condition

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 19, 2017 at 01:21 PM

    hi

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

    condition on new formula-> new formula >=1

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2017 at 07:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded