Hello,

I have two formulas that are using a max summary, these calculate VAT and Gross for each row of an invoice, which are grouped by invoice. Is it possible to get a sum for each invoice, and a total sum of all invoices?

VAT Formula:
if {Saleshistorydtl.Misccode} = "VAT"
or {Saleshistorydtl.Misccode} = "VAT2"
then {Saleshistorydtl.Extdollars}*Maximum ({Saleshistorydtl.Exchgrate}, {Saleshistoryhdr.InvNumber})

Gross Formula:
{Saleshistorydtl.Extdollars}*Maximum ({Saleshistorydtl.Exchgrate}, {Saleshistoryhdr.InvNumber})

I can't go into the details of why I have to use a Maximum in the formula, I just do.

Thanks,
MrCastalum


Edited by MrCastalum - 30 Mar 2010 at 11:24pm