2 times if

[Anonymous]

Hi all,

I have a really difficult problem:

I want to calculate in this way:

if column1 = A,B,C 

and if (A=A(comlumn2);B=B (comlumn2);C=C(comlumn2) then Value(column3)*1; else do Value(column3)*1,1;)

if  column1 = D then  Value(column3)*1

So there are two if sentences.

Thank you for helping!

If you need a better explanation - just tell me! 🙂

[Anonymous]

Maybe this:

Data:

LOAD *,
If(Town1='Berlin' or Town2='Berlin' or Town1=Town2,Value,Value*1.1) as Result
;

LOAD * INLINE [
    Value, Town1, Town2
    3, M, M
    4, FFM, FFM
    5, M, FFM
    6, M, FFN
    754, FFM, M
    3, FFM, FFM
    23, M, FM
    5, Berlin, Berlin
    56, Berlin, FFM
    6, M, M
    1000, x, Berlin
];