Hi All,
Quite frustrated with a formatted search at the moment. Your help is appreciated. I've got an amount and a percentage field. I want to work out the amount after discount.
If I do this calculation in a matrix, it works fine, but on the header of a record it does not. Herewith my queries: (I have the same fields on header of invoice and on rows): Amount field is Units and Totals, Price and Perc field is Units and Totals, Percentage.
In matrix (working):
SELECT $[$38.U_Amount.Number] - ($[$38.U_Amount.Number] * $[$38.U_Perc.Number] / 100)
On header (NOT working):
SELECT $[$U_Amount.0.Number] - ($[$U_Amount.0.Number] * $[$U_Perc.0.Number] / 100)
I have also tried with $[Table.Field], but that doesn't work on either header or lines.
Please help,
Thanks!!!
Adele.