kavi4u 0 Newbie Poster

Hi,

I have a doubt.

in crystal report i need to generate one total column based on a condition.

the field name to summarize is the Paidamount , and it should be summarized only if mode of Payment is equal to "CASH".

so I gave a formula like this
if(tbl_Name.ModeofPayment="CASH")then
sum(tbl_Name.PaidAmount)

i ve to kepp this result in a report footer.

but the result is showing me only 0.00

any one can help me

thanks in advance.