Need to get the Average Discount % of the Order 2

[thi123]

I am trying to calculate the Average Discount % of an Order using the Group result but I was not getting the correct figure. I got the correct figure on the details section using this formula:
OrdAmt-NetAmt/OrdAmt = AveDisc %

Appying this formula on the Group result figure below, I should have gotten a 16.7 % (OrdAmt - NetAmt / OrdAmt)

Structure of my report:
Loc3 OrdAmt NetAmt AveDisc %
1 3000 2500 3000.00%
2 6000 4500 ?

Am I using the wrong formula? Can someone help me with the correct calculation? Please help me...

 

[MrBillSC]

Are you using the Sum function for all the elements of your group calculation?

MrBill

 

[synapsevampire]

Try:

(1-(NetAmt/OrdAmt ))*100

-k

 

[thi123]

Mr BillSC,

Yes I am using the Sum function for all the elements of my group calculation.

sample:

Sum ({@OrdAmt}, {Order.OrdNo})-Sum ({NetAmt}, {Order.ordNo})/Sum ({@OrdAmt}, {Order.OrdNo})

Thanks for all quick reply.

 

[thi123]

synapsevampire,

Thank you so much. Your formula works. I have now the correct values on my report.

You guys are great!!!!

 

[MrBillSC]

Another way to make your formula work is to use the % function:

(Sum ({@OrdAmt}, {Order.OrdNo})-
Sum ({NetAmt}, {Order.ordNo})) %
Sum ({@OrdAmt}, {Order.OrdNo})

MrBill