Summing a specific records

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I want to get the sum of records based on a specific record filter (field
value), in addition to the report total which is the sum of all records. Is
there a way to do that in a report?

Thanks

Regards
 
You could do this in your query that is running the report. Make an expression like
NewNumber: IIF([FieldValue]>100,[Number],0

Then, on your report you can do a sum of the [NewNumber] field

Hope this helps

----- John wrote: ----

H

I want to get the sum of records based on a specific record filter (fiel
value), in addition to the report total which is the sum of all records. I
there a way to do that in a report

Thank

Regard
 
Back
Top