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. 

    See below:



    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