Skip to Content
0
May 25, 2018 at 09:30 AM

Formula help in Crystal reports please

83 Views

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