Hi,
We have a problem, want connect many IF into the formula, that is,
IF Actual1 < Actual2 THEN Actual1
ELSE IF Actual1 < Actual3 THEN Actual1
ELSE IF Actual1 < Actual4 THEN Actual1
ELSE 0.
I saw into SAP Library that one IF is correct, but if I want many Ifs????
Example SAP Library:
IF Actual Costs > Plan Costs THEN Plan Costs + Plan Deviation ELSE Actual Costs
can be written as the following formula:
(Actual Costs > Plan Costs)* (Plan Costs + Plan Deviation) + (NOT (Actual Costs > Plan Costs)) * Actual Costs
Thank you very much.
Oscar