Getting ride of a Zero

AlexForsythe
New Contributor

Getting ride of a Zero

Hi, 

 

I need to get ride of Zero's in a Override line item, so the model doesn't read it as an override? I understand this should have been set up with a Boolean in the first place but it's a little late for that. I now need to get ride of all user inputs which include Zeros.

 

Thanks 

1 REPLY 1
obriegr
Certified Master Anaplanner

Re: Getting ride of a Zero

Add a line item that states Has an override?, that is a boolean. Then if the boolean is checked then take the entry. 


See below:

obriegr_1-1630521304094.png

obriegr_0-1630521270174.png

I would write:
Line Item: Overwrite?

FORMULA: New Forecast <> 0


As soon as I have deployed it (if using ALM), I would then remove the formula, and deploy again.


This should resolve the issue and give your users further control. In addition, I would eventually add conditional formatting to both the Overwrite and Overwrite? line items