I am using nested IF statements tied to a checkbox to derive the value to be used in a sum for pipeline forecasting. In this case, the item is either being acquired or resold.
Here is the formula.
IF({Incl in Pipeline?}, IF({Net Cash Proceeds} = “”, -1*{Total Cash to Acq}, {Net Cash Proceeds}),“”)
The logic appears to work EXCEPT when the box is checked and the Net Cash Proceeds is null. In that scenario, it delivers a value of “0”. I can’t figure out what I’m doing wrong.