Totals

[theitman]

I'm stumped. I have an unbound control that looks like this:

=IIf([Date Report Rcvd]-[Date Claim Rcvd]>45,1,0) ---this is working ok

The field is currently located in the detail section of my report. Date
Report Rcvd and Date Claim Rcvd are both fields located in the same table. I
need to come up with a percentage of how many records are 1 and how many are
0. I have no idea how to do this. There are no groupings on my report.
Thanks

 

[Duane Hookom]

Try this for one calc:
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]>45) ) / Count(*)
And
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]<=45) ) / Count(*)

These should work in a Group or Report Header or Footer.

 

[theitman]

It worked perfectly! Thanks!

Try this for one calc:
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]>45) ) / Count(*)
And
=Sum( Abs([Date Report Rcvd]-[Date Claim Rcvd]<=45) ) / Count(*)

These should work in a Group or Report Header or Footer.

--
Duane Hookom
MS Access MVP
--

I'm stumped. I have an unbound control that looks like this:

=IIf([Date Report Rcvd]-[Date Claim Rcvd]>45,1,0) ---this is working ok

The field is currently located in the detail section of my report. Date
Report Rcvd and Date Claim Rcvd are both fields located in the same table.
I
need to come up with a percentage of how many records are 1 and how many
are
0. I have no idea how to do this. There are no groupings on my report.
Thanks