Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum_Table2:
LOAD
PordCode,
ProdName,
SIMCode,
num([Sls Amt],'###0.00') as [Sls Amt],
num(COGS,'#,##0.00') as COGS,
num(%COGS,'#,##0.00') as %COGS,
num([Gr Margin],'#,##0.00') as [Gr Margin],
num([%Gr Margin],'#,##0.00') as [%Gr Margin]
FROM
[..\Qvds\Item_Margin.qvd]
(qvd);
load
PordCode,
ProdName,
sum( [%Gr Margin])
//count([%Gr Margin]) as [%Gr Margin]
Resident Sum_Table2
Group By PordCode;
drop table Sum_Table2;
Gives error invalid expression any body got such issues ?
Vikas
you should group by prodname as well.
group by pordcode, ProdName;
Add ProdName as well in the group by clause like:
....
Resident Sum_Table2
Group By PordCode, ProdName ;
Thanks
Thanks