Skip to Content
0
Former Member
Feb 20, 2009 at 08:40 AM

Average in grouping Sum

19 Views

Hi Experts,

I have come out a report with is Total amount / Qty = Unit price. at Group 1, When i wanna to do same thing in Group 2 then it's wrong unit price after divided. It's follow the Group 1 unit price.

Sum ({@Delivered Total}, {v_ARCN.ItemCode})/count({v_ARCN.Quantity}, {v_ARCN.ItemCode})

Please kindly advise.

Thanks.

Regards,

Danny.