Hi,
I have two columns in the report query that comes from the database namely DR-Amountand CR-Amount. I am creating a third column in the report using a formula that says that if CR-Amount is not equal to 0 return that value else return previous value of formula + dramt but it gives me error saying "A formula cannot refer to itself either directly or indirectly"
Below is what I want :
if {command.CR-Amount}<>0 then
{command.CR-Amount}
else
previous({@ActRunningBal})+({command.Dr-Amount})
How Can I achieve this?
Thanks in advance
Reena