Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Why when Numerator is blank does Divide not return the Alternate result?

I thought the key purpose of Divide was to protect against numerator errors and zero division.    On my current report I have blanks (BLANK()) as my Numerator and when this is the case Divide retur...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may add +0 in your formula to avoid using IF condition. Measure =

    DIVIDE([MyTrue]+0,[myTrue]+[MyFalse])

    For example:

    Regards,

    Cherie