Subreports in Crystal Reports 9

[donnarenia]

I am using this formula to get a dollar amount if the Cash type equal "A" (for Adjustment) and if it does equal adjustment I need it to Subtract the Cash.Amount from the Final Bill amount BUT if it equals "P" (for payment) I want it to just show the final bill amount

My Formula:
if {CASH.Type} = "A"
then {CASH.Amount}={AR.FinalBillAmt}-{CASH.Amount}and
if {CASH.Type}="P" then {CASH.Amount}= {AR.FinalBillAmt}

But when i put it in my report, it shows "FALSE" what can I be doing wrong

 

[kray4660]

You have to use ":=" for assignment statements. I have done this way too many times.

if {CASH.Type} = "A" then {CASH.Amount}:={AR.FinalBillAmt}-{CASH.Amount}and
if {CASH.Type}="P" then {CASH.Amount}:= {AR.FinalBillAmt}

 

[donnarenia]

Great....I entered your formula but receive the following error message:

the remaining text does not appear to be part of the formula

 

[kray4660]

I did not notice the 'And' between the if statements. Probably should an 'else'.

if {CASH.Type} = "A" then {CASH.Amount}:={AR.FinalBillAmt}-{CASH.Amount} else
if {CASH.Type}="P" then {CASH.Amount}:= {AR.FinalBillAmt}

Now if {CASH.Type} is neither "A" or "P" then nothing will be returned.

 

[lbass]

if {CASH.Type} = "A" then
{AR.FinalBillAmt}-{CASH.Amount} else
if {CASH.Type} = "P" then
{AR.FinalBillAmt}

-LB