Skip to Content
0
Former Member
Sep 22, 2005 at 10:01 AM

Formatted Search Inconsistency

16 Views

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.