Report Sum - Conditional Sum

[Kirk P.]

I am trying to find a way to perform the following:

I have sales records by "store" and by "job". For example

Store Job Sales
East 1 100
East 2 125
West 2 150
West 3 175
Central 3 200
Central 1 105

When reporting, all records appear in the detail section,
and I can group and sum by Store and/or Job. However,
let's say I only want to group and sum for Jobs 1 & 2. I
don't want the totals for job 3 to appear in the sum of 1
& 2. I want to display a subtotal for jobs 1 & 2, and a
SEPARATE subtotal for job 3.

Is there an easy way to do this?

 

[Duane Hookom]

You can add a text box to a group or report footer that uses syntax like:
=Abs(Sum( (Job=1 or Job=2)*Sales) )
This will sum Sales for only Job 1 or 2.

 

[Kirk P]

Thanks, that works perfectly. I never would have guessed
that this function would work that way.