Have a count in %

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
 
D

Douglas J. Steele

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
 
Top