Hello everyone,

 

 

I am trying to sum a field in a report when the field is a certain value (in this case, "F") however, no matter how I tweak the formula or try to rewrite it - i always get a returned value of 0.00. How can I count a field when the field is a certain value - nothing seems to be working.

 

 

Thanks!

 

convert the value to 0 or 1 then sum that

Used variable formula to count based on an if then statement

or

use a running total

name=F_Count

field to summarize=F field

type=Count

evaluate=use a formula

table.F-Field='F'

reset=never (for a grand total)

Place in report footer