Invalid Expression

[qlikviewaf]

Invalid expression

F42119:

LOAD *,

((Num(If(Match(LineType,'B','BF','BN','BX','CD','CM','CN','EC','F','FN','N','IA','IC','J','JN','K','L','LC','M','N','N1','N2','N3','N4','NA','NK','NS','P','R','SI','SM','T','T1'),0,UnitCostUSD))*OrderCostQty))+ExtendedCostUSD as ExtendedCostUSDADJ,

(ExtendedUSD-sum((Num(If(Match(LineType,'B','BF','BN','BX','CD','CM','CN','EC','F','FN','N','IA','IC','J','JN','K','L','LC','M','N','N1','N2','N3','N4','NA','NK','NS','P','R','SI','SM','T','T1'),0,UnitCostUSD))*OrderCostQty)+ExtendedCostUSD))/ExtendedUSD as MarginUSD

RESIDENT F42119Temp2

i got this error, anyone knows why? i'm driving crazy..

Thanks!

[el_aprendiz111]

Hi Antonio

sum((Num(If(Match

Group By ......

You could share a sample of data.

[Anil_Babu_Samineni]

Can you share full script here?