Demo -> Invoices -> Invoices with Groups has incorrect grand total

[chris.procter]

Hello

I'm trying to write a categorized report with subtotals and a grand total. I couldn't get the grand total though, so I looked through your demo reports.
The "Invoice with Groups" report is pretty much exactly what I'm trying to do, but it has the same problem my report does. You'll note that the grand total (4238.45) is far less than what it should be. (It's actually a sum of the first item in each category, not all items.)

I'd be interested in how to do this operation properly.

Thanks!

[Edward]

Hi Chris,

Yes, you are right, thank you for this.

Please use the following expression there instead:

{Sum(Data1:DataBand1,Products.UnitsInStock * Products.UnitPrice)}

Thank you.

[chris.procter]

Thanks! My report totals work great now.

[Edward]

Hi Chris,

Please let us know if you need any help.

Thank you.