How to get a neat indented version of a long IF Else statement. Other than the drill down that one can do within Anaplan, it doesnt work every time.
Solved! Go to Solution.
Sales + (IF Include Optional Adjustments? THEN Optional Adjustments ELSE 0) + Mandatory Adjustmentsthe drilldown viewer will display this as Sales + IF Include Optional Adjustments? THEN Optional Adjustments ELSE 0 + Mandatory Adjustments ...which if you capy & paste it back into Anaplan ends up as
Sales + IF Include Optional Adjustments? THEN Optional Adjustments ELSE 0 + Mandatory AdjustmentsNote the missing brackets around the IF statement. The result is different too; the original version always added the mandatory adjustments, but the new version only adds them when the optional adjustments are switched off. So I'd advise caution when copying & pasting from the drilldown view.