Formula or Filter

Human008
edited February 2023 in Modeling

Hello Everyone,

I need here in getting solution for this issue, my question is.

"change rule: when Forecast AND Actual equals 0, the deviation % should be 0% and not 100% as now" so where do we change the rule and how do we do it.

 

welcome to hear solutions, Thank you.

Answers

  • @Human008 If I understand your question properly then you just need to change the "THEN 1" to say "THEN 0" and change the OR to an AND

     

    jasonblinn_0-1613024662512.png

     

    Hope this helps,

    Jason