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 

Tagged:

Answers

  • 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