% Change to Zero in Offset when Numerator is zero

[ysherriff]

Hi all,

I am trying to get the value to display “0” when the numerator is zero. I am using the Switch statement with Isblank and it is showing -100% but should be 0%.

Can someone direct me to what I am doing wrong?

[ysherriff]

Thank you all. I found the solution. Wrap Divide into an If statement

Thank you much