Thanks Kostya1122 and Lockwell.
I found out that there's an exchange rate field which I can use to do the converting..(My bad) Thanks a lot for your help though.
There's a one last question and i hope it'll solve the problem..
"How do I add the subtotal for a field that has a suppression formula in it? "
To make it clearer. I have a field called "Calc_AgeInvAmt1" that shows the value of the Future invoice amount. In the format field, in the Common Tab, the Suppress box is ticked and has a formula in it which is..
((not PreviousIsNull ({ARDTLS.InvoiceNum}) and (Previous ({ARDTLS.InvoiceNum}) = {ARDTLS.InvoiceNum}))
and
{@RecNum} > 1) or ({ARDTLS.Calc_AgeInvAmt1} = 0)
So it only shows the invoice amount that is due within the next 2 weeks or so and suppressed the ones that are not.
My problem is if I make a running total using this field, I get the sum of all the invoices including the suppressed ones. I only want the sum of all the visible amount shows in this column.
How do I do this please?
Thanks in advance...
Edited by khyulitz10 - 11 May 2012 at 5:06am
IP Logged
