if else

[bharatkishore]

HI All,

i have two conditions written i.e.

if(Country='Brazil' and Strategic_Part='Tubes',    

if(not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.055),

if(Strategic_Part<>'Tubes' and not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.200,

if(IsNull([U-D_NL9s]) or [U-D_NL9s]=0 or [U-D_NL9s]=0.01, [mat con loc cur]*1*-1))) ,

if (Match(Country,'Russia','Russian Federation','Indonesia') and Strategic_Part='Tubes',

if(not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.055),

if(Strategic_Part<>'Tubes' and not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.270,

if(IsNull([U-D_NL9s]) or [U-D_NL9s]=0 or [U-D_NL9s]=0.01, [mat con loc cur]*1*-1))) as T1

My first condition(else part not happening) is not working the formula where i have renamed T1 only it is considering ..

Can you please help me where i have missed out.

Thanks,

Bharat

[shansundar]

Try this one,

if(

(if(Country='Brazil' and Strategic_Part='Tubes',   

if(not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, 1),

if(Strategic_Part<>'Tubes' and not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, 1,

if(IsNull([U-D_NL9s]) or [U-D_NL9s]=0 or [U-D_NL9s]=0.01, 1,0))

)

) = 1

,

if(Country='Brazil' and Strategic_Part='Tubes',   

if(not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.055),

if(Strategic_Part<>'Tubes' and not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.200,

if(IsNull([U-D_NL9s]) or [U-D_NL9s]=0 or [U-D_NL9s]=0.01, [mat con loc cur]*1*-1)))

,

if(Match(Country,'Russia','Russian Federation','Indonesia') and Strategic_Part='Tubes',

if(not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.055),

if(Strategic_Part<>'Tubes' and not IsNull([U-D_NL9s]) and [U-D_NL9s]<>0 and [U-D_NL9s]<>0.01, mat_con_qua*-1*[U-D_NL9s]*1.270,

if(IsNull([U-D_NL9s]) or [U-D_NL9s]=0 or [U-D_NL9s]=0.01, [mat con loc cur]*1*-1))

)

) as T1

Thanks,

Shan S

[bharatkishore]

Thank you SS

[bharatkishore]

Thanks a lot sunny bhai .. and really sorry if i keep on asking you.. sorry sunny bhai.. and thanks a lot.