cancel
Showing results for 
Search instead for 
Did you mean: 

Connect IFs

Former Member
0 Kudos
109

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

View Entire Topic
klaus_buchner2
Explorer
0 Kudos

Hy Oscar, this formula should work:

( Actual1< Actual2 ) * Actual1 + ( Actual1 < Actual3 ) * Actual1 + ( Actual1 < Actual4 ) * Actual1 + (NOT ( Actual1< Actual2 ) ( Actual1 < Actual3 ) ( Actual1 < Actual4 )) * 0

We had a problem that BI didn't recognize the second, third, ... condition but this seems to be solved with Support Package 13.

Regards

Klaus