Have a question about the Grand Totals for these columns. Since the old version is based on Order Transactions, when I create a formula for the grand total it is duplicating the order total based on how many line items are in the order. For my example there are 3 line items in one order and the order total is $524.00. It is adding that up 3 times and then adding the order total for the next order grouping (2nd order total is $79.13). So my grand total is = $1651.13 when it should be $603.13. Here is a copy of the Grand Total formula:
IF {SP_LegalItemizedBill.OrderNo} < 1500000
THEN sum({SP_LegalItemizedBill.InsARAppliedB4V2})
ELSE sum({SP_LegalItemizedBill.InsARApplied})
This is the formula I used to get each orderno group total:
IF {SP_LegalItemizedBill.OrderNo} < 1500000
THEN {SP_LegalItemizedBill.InsARAppliedB4V2}
ELSE sum({SP_LegalItemizedBill.InsARApplied},{SP_LegalItemizedBill.OrderNo})
Anyone know how I get the old version order total to not duplicate for my Grand Total?
Thanks!!!
IP Logged
