Sum and or Iif

F

frustratedwthis

I am trying to make an expression on a report that will sum all amounts under
"Rec" that have "GF" under Funding source.
ex.
Rec NR Funding Source
$10 PYFB
$15 GF
$20 GF
$15 GF

I would like to return the total of $25
Can this be done?
 
K

KARL DEWEY

Please educate me as my limited math skills total $50 for those thar have
"GF" under Funding source.
 
F

frustratedwthis

The total of ALL GF's is $50, however, the total under REC is only $35 (which
was a typo in the original post)
I did figure this out using
=Sum(IIf([Funding Source]="General Fund ",([Recurring]),0))
Thank you.
 
J

Jackie L

In your query which runs the report, create a new field:
NewFieldName: IIF([FundingSource]="GF",[Rec],0)

Then, on your report you can sum the new field.

Hope this helps.
Jackie
 
Top