Skip to Content
avatar image
Former Member

How to determine if Key Figure is a whole number (no numbers after decimals)

Hi,  anyone know how to do this:   Alert KF:    If KF1 / KF2 is a whole number (no numbers after decimals),  then alert is 1 otherwise 0.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 29, 2015 at 03:47 AM

    Hi,

    Try this:

    Alert KF = IF(((KF1/KF2)%1)=0,1,0)

    Regards,

    Kent

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kenton Harman

      Thanks Kent!  I was looking in the 4.0 FP01 Patch 3 model configuration guide and didn't see modulus functionality.  But your right,   it has been added since then.

      Regards