calculations on my report!

[Guest]

my information on the report comes from a crosstab query, I want to do some
calculations on the report footer but am not sure how to... ie the
ontime/total produced

W2 1040 1099
OnTime: 35 43 10
OutStd : 22 58 8

 

[Duane Hookom]

I assume you have a field with values of either OnTime or OutStd. Assume
this field is named [Status].
A guess might be a control source like:

=Sum(Abs(Status="OnTime") * W2)/Sum([W2])

BTW: W2 Total Produced should be 57, not 77.

 

[Guest]

Thanks alot that worked very well.

Thanks for the calculations check!

I assume you have a field with values of either OnTime or OutStd. Assume
this field is named [Status].
A guess might be a control source like:

=Sum(Abs(Status="OnTime") * W2)/Sum([W2])

BTW: W2 Total Produced should be 57, not 77.