sum in a report

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

Guest

I am having trouble summing for specific criteria. I have a group called
SType and another group under that called MType. I want a subtotal of all
amounts that have a transaction type of "REDEMPTION" and another subtotal for
all transation type of "PATRONAGE EQUITY" for the SType group. I have tried
running sums on groups to no avail. Now I have done the following, but it
also doesn't work any suggestions are very welcomed.

I have a field called [ReTo]
=IIf([TRANSACTION NAME]="redemption",[Amount],0) in my detail section

Another field called [PaTo]
=IIf([TRANSACTION NAME]="patronage equity",[Amount],0) in my detail section

this gives me what I expected, in my detail section it gives me an amount if
the statement is true and a 0 if false

then in my Stype footer I have two fields called [ReTot] and [PaTot] and
each one of them is a running sum on [ReTo] and [PaTo] - but it isn't summing

If Redemption was the last line of the detail it will pick it up, but if not
it doesn't and the same holds true for patronage equity
 
Did you try this for the Sum

=Sum(IIf([TRANSACTION NAME]="redemption",[Amount],0))

=Sum(IIf([TRANSACTION NAME]="patronage equity",[Amount],0))
 
Ah yes - thank you

Ofer said:
Did you try this for the Sum

=Sum(IIf([TRANSACTION NAME]="redemption",[Amount],0))

=Sum(IIf([TRANSACTION NAME]="patronage equity",[Amount],0))

--
\\// Live Long and Prosper \\//
BS"D


cmk said:
I am having trouble summing for specific criteria. I have a group called
SType and another group under that called MType. I want a subtotal of all
amounts that have a transaction type of "REDEMPTION" and another subtotal for
all transation type of "PATRONAGE EQUITY" for the SType group. I have tried
running sums on groups to no avail. Now I have done the following, but it
also doesn't work any suggestions are very welcomed.

I have a field called [ReTo]
=IIf([TRANSACTION NAME]="redemption",[Amount],0) in my detail section

Another field called [PaTo]
=IIf([TRANSACTION NAME]="patronage equity",[Amount],0) in my detail section

this gives me what I expected, in my detail section it gives me an amount if
the statement is true and a 0 if false

then in my Stype footer I have two fields called [ReTot] and [PaTot] and
each one of them is a running sum on [ReTo] and [PaTo] - but it isn't summing

If Redemption was the last line of the detail it will pick it up, but if not
it doesn't and the same holds true for patronage equity
Click to expand...
Click to expand...
 
Back
Top