Getting ride of a Zero
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.
Add a line item that states Has an override?, that is a boolean. Then if the boolean is checked then take the entry.
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 items0