conditional sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an order’s report.
The detail section has the item movements.
Every item is either type A or type B.

At the report footer I would like to have an item movement summary by type.
This is, I would like to sum the quantities on the detail section for type A
and for type B. Something like:
Type A - X
Type B - Y

Can anyone give me and idea of which function should I use?

Many thanks in advance
 
Raul said:
I have an order’s report.
The detail section has the item movements.
Every item is either type A or type B.

At the report footer I would like to have an item movement summary by type.
This is, I would like to sum the quantities on the detail section for type A
and for type B. Something like:
Type A - X
Type B - Y
Click to expand...


Use the Sum function in the report footer section text
boxes:

=Sum(IIf(type = "A", quantity, 0))
 
Back
Top