Hi all,
I need to add the Sum of 3% Parts ( which seems to be a sum at the Group 2 level) and 3% Freight but I cant seem to get them to add correctly.
Any help is greatly appreciated.
---
Parts Extension
IF {AR_InvoiceHistoryDetail.ItemType}="1" THEN {AR_InvoiceHistoryDetail.ExtensionAmt} ELSE 0.00
3% Parts
{@Parts Extension}*.03
Sum of Parts Extension
Sum ({@Parts Extension}, {AR_InvoiceHistoryHeader.InvoiceNo})
Sum of 3% Parts
Sum ({@3% Parts}, {AR_InvoiceHistoryHeader.InvoiceNo})
3% Freight
({AR_InvoiceHistoryHeader.FreightAmt})*.03