Calculation on Report

[Joyce]

On my report I want to show if the established turnaround
days was met for each case. I have two fields, one is
[TA2004] which calculates the turnaround time for each
record. The result is an numeric value. The next field is
[GoalTurnaround] wich is also a numberic valu. I'm trying
to count the number of records where the [TA2004] is less
than or equal to the [GoalTurnaround]. I tried varius
versions of this code and just can't seem to get it to
work. Any help you can give me is appriciated.

=Count([TA2004])<=([GoalTurnaround])
I also tried
=Count(IIF(DifF("d",[TA2004]<= [GoalTurnaround]))

 

[John Vinson]

On my report I want to show if the established turnaround
days was met for each case. I have two fields, one is
[TA2004] which calculates the turnaround time for each
record. The result is an numeric value. The next field is
[GoalTurnaround] wich is also a numberic valu. I'm trying
to count the number of records where the [TA2004] is less
than or equal to the [GoalTurnaround]. I tried varius
versions of this code and just can't seem to get it to
work. Any help you can give me is appriciated.

=Count([TA2004])<=([GoalTurnaround])
I also tried
=Count(IIF(DifF("d",[TA2004]<= [GoalTurnaround]))

It's a bit counterintuitive, but you can best get this count using
Sum. Put a field in the Query upon which the report is based defined
as

MetGoal: IIF([TA2004] <= [GoalTurnaround], 1, 0)

This will be equal to 1 for each record where the goal was met, 0
otherwise. You can then Sum it in the footer of your report.