Total Field Error - Help!

[seg0906]

Hi,____I^m having problems with a total field:____Mom has a field called TB_Tax in the CMS table - which is the sales tax for an order. ____I have a field caled ordersaleamount = which is a totals the individual item sale amounts per order (RESETTING total on the order level). ____I have a field called ordersaleamountTAX - which totals only the taxable sales on a order. (RESETTING total on the order level) ____I^ve created a field called CalcTax - which calculates tax by multiplying the ordersaleamountTAX * salestax percentage. ____Now - if I want to complete a grand total for the tax data two scenarios occur:____1. If I do a grand total based on the TB_TAX field and set the accumulation to the ORDER level - I get the correct total.____2. If I do a grand total based on hte CalcTAX field - and set the accumulation to the ORDER level - I get an incorrect total. If I set the accumulation to Automatic - I get no total (zero). ____I really need the sum of the CalcTAX field (it calculates my line item tax accurately) - however no matter what I do - I cannot get the total to work. ____Any ideas? Thanks for your help!__Sarah

[kfleming]

What if you change CalcTax to take the line item amount times the sales tax percentage and then do a grand total of that calculation?____Kathleen__R&R Support__ __

[seg0906]

Thanks - that^s a great idea - it worked!____Sarah