I have the following nested if, for the highlighted line item (see picture):
IF NOT 'exclude' AND 'Sum fill rate gallons actuals' > 0 THEN 'Sum fill rate gallons actuals' ELSE IF 'Sum fill rate gallons PY' > 0 THEN 'Sum fill rate gallons PY' ELSE IF 'fill rate gallons FOR movement avg' > 0 THEN 'fill rate gallons FOR movement avg' ELSE 0
The highlighted row should be returning one of the other line items and it's giving me complete different results. There is no version on this module or the module the original data comes from. Any thoughts, or is my formula too complex? Thank you so much for any suggestions.