Line Total

  • 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.

  • Try without the SUM. I'm not the reporting pro, but usually SUM is a aggregate function. Try "Fiel1 + Fiel2 + Field3 + Field4 + Field5"

  • That worked, but why?

  • 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