if condition

[bharatkishore]

Hi All,

I am writing the below expression in script.. but my expression is not working..Can you please tell me where i am missing out..

if(Country='Brazil' and Batch_Code='U',

if(Strategic_Part='Tubes' and [U-D_NL9s]<>0 ,sum(mat_con_qua)*(-1)*sum([U-D_NL9s])*1.055,0)) as test

Thanks,

Bharat

[Peter_Cammaert]

What do you mean by "Calculated field"? A field is a field and it must be present in the source table before you can LOAD...GROUP BY it into a new table.

[olivierrobin]

if the field is used to name a formula (after AS in the same load), you have to replace it by it's corresponding formula

[bharatkishore]

Thanks Nagaraju..

It is working exactly.. Can you please tell me where i have missed out

[bharatkishore]

Thanks a lot Oliver..

[bharatkishore]

Thanks a lot Peter..