Forum Discussion
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
- Try this =IFERROR(( [% 2020] - [% 2019] ) / [SQRT_]),0)
2 Replies
- Try this =IFERROR(( [% 2020] - [% 2019] ) / [SQRT_]),0)
That did it, thank you!