Forum Discussion

adavid999's avatar
adavid999
Icon for Helper V rankHelper V
6 years ago
Solved

IFERROR

Hi there, please can someone tell me how to insert iferror function on this measure to prevent #NUM! where difference is 0   =( [% 2020] - [% 2019] ) / [SQRT_] Many thanks, A
  • satyanarayan's avatar
    satyanarayan
    6 years ago
    Try this =IFERROR(( [% 2020] - [% 2019] ) / [SQRT_]),0)
satyanarayan's avatar
satyanarayan
New Member
6 years ago
Try this =IFERROR(( [% 2020] - [% 2019] ) / [SQRT_]),0)
  • adavid999's avatar
    adavid999
    Icon for Helper V rankHelper V
    6 years ago

    That did it, thank you!