Mulitple IF statements in a formula

[Maggied]

Hi,
I came across this a long time ago and I can't remember what I did for this to work. Basically in the below formula only the first line works. When the {APTCP.TRXTYPE}) = 51 it will display Payment but when its the second it displays nothing.
I can't remember what I am doing wrong. Thanks

if {APTCP.TRXTYPE}) = 51 then "Payment"
else
if {APTCP.TRXTYPE} = 57 then "PrePayment"
Else
"Misc Payment

 

[kray4660]

The code looks pretty correct (except for mismatched parans on the first line, which should give you an error).

 

[Maggied]

yah that extra ) isn't in my formula sorry. But it will work only on the first if statement

 

[lbass]

YOu might want to add a null check at the beginning of the formula:

If isnull({table.field}) then
"" else
If ...

If that doesn't help, then please explain how you are using this formula and in what report section you are placing it.

-LB

 

[Maggied]

Hi,
I was able to get the first two working. It had to do with my linking but now the third one will display the second ones result. I think I know the issue why but is there another formula to do it. If the record doesn't exist in the table aptcp I want it to return a value of MISC PAYMENT. What would be the formula?

 

[lbass]

If isnull({aptcp.field}) then
"Misc Payment" else
If (etc.)

The null check must be first.

-LB