Formula or Filter

u381725
New Contributor

Formula or Filter

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.

1 REPLY 1
jasonblinn
Master Anaplanner/Community Boss

Re: Formula or Filter

@u381725 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