Hi Friend,

I have made purchase order report. For each row, I am getting amount by calculating =[unitRate] * [Quantity] and its working perfect.

At the end I want to show total value. I have mentioned =sum([unitRate] * [Quantity]) but showing #Error... any clue

thanks

mithani

you need to have the total: [unit rate] * [quantity] as a column your query, then you can sum the total with no problem

dear gemma,

Thanks man. I have tried but still showing error.

any idea

mithani

Where on the Report are you doing the Sum?

hi rich,

Yes I am doing on report.

please help me

i made it..... thanks