Skip to Content
0
Former Member
Mar 19, 2009 at 03:56 PM

Problem in Creating Formula

366 Views

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