I have a report that has 5 running totals, calculations are done on these totals to achieve a final balance. I would like to pull a report that uses a database field against the final balance. For example :
(#rt1) + (#rt2) - (#rt3) + (#rt4) = balance
db.current_balance <> balance
I have tried to enter a formula such as the one above, I am recieving a message that says the formula cannot be evaluated at the time specified.
Any suggestions on how to fix this.
My main dilemna is that I am trying to use a formula field as a record selection, I know that the formula will have to be evaluated first before record selection is done. What would be my options?
Edited by bahamaER - 01 May 2008 at 3:38pm
IP Logged