group by with num function is not working

[vikasmahajan]

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

[#2 · Accepted solution]

you should group by prodname as well.

group by pordcode, ProdName;

[tresesco]

Add ProdName as well in the group by clause like:

....

Resident Sum_Table2

Group By PordCode, ProdName ;

[vikasmahajan]

Thanks

[vikasmahajan]

Thanks