Page 1 of 1

Summing mutliple columns

Posted: Thu Jun 10, 2010 4:53 pm
by MikeC
I'm working on a report that has Sum fields for 3 columns of data (Land value, Building value and Dwelling value). All 3 are on the group footer.

I need a total for all 3 for each and I'm not finding a way to do it. How does the software handle sums when there are multiple columns?

Summing mutliple columns

Posted: Fri Jun 11, 2010 2:24 am
by Jan
Hello,

You can use expresssion something like this:

Code: Select all

{Sum(MyDataSource.Land + MyDataSource.Building + MyDataSource.Dwelling)}
Thank you.

Summing mutliple columns

Posted: Fri Jun 11, 2010 11:44 am
by MikeC
Thanks-worked perfect.

Summing mutliple columns

Posted: Fri Jun 11, 2010 1:08 pm
by Andrew
That is very good!