June 26, 2009 at 3:22 pm
Greetings all!
I'm trying to get the total of 5 fields in my report that is grouped by a particular number.
Example is this
GroupByValue
-----------------------------------------------------------------------------------------------------
Date Field Record Number Title Field1 Field2 Field3 Field4 Field5 Total
-----------------------------------------------------------------------------------------------------
01/01/09 1 A Title 1 2 14 3 35 X *
05/22/09 2 Second Title 3 4 11 7 12 X *
* Need This To Total Fields 1-5 for each record
I need to get the total my thoughts were since it is grouped by a particular value I can simply sum(field1+field2+field3+field4+field5)
However that doesn't work and the expression is the same for each record.
Help.
June 26, 2009 at 3:25 pm
Try without the SUM. I'm not the reporting pro, but usually SUM is a aggregate function. Try "Fiel1 + Fiel2 + Field3 + Field4 + Field5"
June 26, 2009 at 3:30 pm
That worked, but why?
June 26, 2009 at 3:35 pm
rsheppick (6/26/2009)
That worked, but why?
:hehe:
As I wrote, SUM is a function to aggregate multiple rows into one like:
Name AnyNumber
ABC 1
ABC 1
DEF 2
DEF 4
GHI 5
Group(Name) SUM(AnyNumber)
ABC 2
DEF 6
GHI 5
SUM/AVG/COUNT/MIN/MAX/... functions are made to merge several rows into one. Columns which are not aggregated need to be grouped.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply