Have a count in %

  • Thread starter Thread starter Fred's
  • Start date Start date
F

Fred's

Hello,

On my report, I have the following formula into a text box which
calculate how many shipment not on time.
=Count([Store])-Sum(nz([Différence D'Heure],0))

And this other formula that calculate how many stores I have
=Count([Store])

Now i will like to calculate how many shipment not on time.
but in pourcentage.

What will be the formula?

Thanks for your help!

Fred's
 
That would be the number of late shipments divided by the total number of
shipments.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello,

On my report, I have the following formula into a text box which
calculate how many shipment not on time.
=Count([Store])-Sum(nz([Différence D'Heure],0))

And this other formula that calculate how many stores I have
=Count([Store])

Now i will like to calculate how many shipment not on time.
but in pourcentage.

What will be the formula?

Thanks for your help!

Fred's
 
Back
Top