Summing Groups

[athyeh]

Hi Folks,

Developing a report today and have another question:

I have a report that is grouped as follows:
Operator
Month
Date
Sort by Process
Process

Within Process there are two options: A and B

I have also added in a Totals Function (Sum) To total so the report looks like this:

JohnSmith
10
10/1/13
A 13


B 14
27

Is there anyway to add a sum on the bottom that shows the sum for A and B as part of the Grand Total?

So:

Total A 100
Total B 200
Grand Total 300

Thanks!

[June7]

Try:

Sum(IIf([Sort By Process]="A",[Process],0))

Sum(IIf([Sort By Process]="B",[Process],0))

[athyeh]

Returns: #Error

[June7]

Did you do this in a textbox? Did you include the = sign in front of expression? Did you use your actual field names?

[athyeh]

Hi June,

I believe so, unless [sort by process], and [process] were variables that I needed to change as well?

Sum(IIf([Sort By Process]="B",[Process],0))

[June7]

If you have the = sign and correct field names and the textbox is in a footer section, that should work. Otherwise, I would have to analyse db. If you want to provide, follow instructions at bottom of my post. Identify report involved.