I have built the following formula that checks a checkbox and, if checked, checks another field to see if that is null. If the field is null, then it pulls a [negative] value from another field. If not null, then it pulls the value from the first field.
IF({Incl in Pipeline?}, IF({Net Cash Proceeds} = ββ, -{Total Cash to Acq}, {Net Cash Proceeds}),ββ).
All of the logic seems to be working except for when itβs supposed to pull the -{Total Cash to Acq} number. When the logic runs into this scenario, the formula returns a value of β0β. Any ideas?