Formula help in Crystal reports please

[former_member529017]

Hello Friends,

I have one column that is BILL NUMBER. and 2 measures Payments and Receipts. I need to add one more column on this. Which is challan number.

When there is Receipt amount is appearing show it as challan number.

When there is Payment show it as Bill number. how to write formula for this. Presently

Bill number Payment Receipt

10100010 0.00 100.00

10100011 0.00 200.00

10100012 30.00 0.00

Thanks

Radhika

[abhilash_kumar · Accepted solution]

Hi Radhika,

Try:

If {receipts} > 0 Then {Challan Number}
Else if {payments} > 0 Then {Bill Number}

-Abhilash

[former_member529017]

Thank you Abhilash...It worked well..