why is calculation is wrong

  • Thread starter Thread starter CAMI Lady
  • Start date Start date
C

CAMI Lady

When number is calculated in Excel or by using a calculator the answer is 3.25%
in a calculated field on my form the answer is 3.36%
calculation in field is:1-([CycleGA])/([TaktTimecal]), because I need to see
what the over/under percentage is
[CycleGa] is number entered by user 1.49 on form
[TaktTimecal] is calculated in the query
[MinutesPerShift]/[VehiclesPerShift]*[Uptime]
[MinutesPerShift] is entered by user (430), [VehiclesPerShift] is calculated
in query (265), [Uptime] is entered by user (.95). The Takt TimeCal comes to
1.54
I tried changing everything to currency, no luck there and have been
Googling and checking this forum for a solution.
I am completely self taught so its probably something really obvious.
Waiting with my fingers crossed
CAMI Lady
 
This is probably just down to the order of calculating your TaktTimecal.

If you do ([MinutesPerShift]/[VehiclesPerShift]) *[Uptime] you get 1.54.
However, if you do [MinutesPerShift]/ ([VehiclesPerShift]*[Uptime]) you get
1.71.

That is probably your discrepancy, so just make sure the right parts are
being calculated together.

Hope that helps.

Steve C
 
The calculated field in your query is probably actually returning a number
like;

1.54150941462.....

which is throwing off your calculation. Try formatting the calculated field
in your
query so it only returns two decimal places;

Format([MinutesPerShift]/[VehiclesPerShift]*[Uptime], "#.##")

_________

Sean Bailey
 
Hi Cami

The actual result from the Takt TimeCal is 1.541509434 not 1.54. If you
plug
that into your Excel calc you will get 3.34%. That assumes that MPS is 430,
VPS = 265 and UPT = .95 (all exactly). Plugging those values into Access
text boxes gives the same answer.

Regards

Kevin
 
Awesome, you people rock, thanks for the quick response
kc-mass said:
Hi Cami

The actual result from the Takt TimeCal is 1.541509434 not 1.54. If you
plug
that into your Excel calc you will get 3.34%. That assumes that MPS is 430,
VPS = 265 and UPT = .95 (all exactly). Plugging those values into Access
text boxes gives the same answer.

Regards

Kevin




CAMI Lady said:
When number is calculated in Excel or by using a calculator the answer is
3.25%
in a calculated field on my form the answer is 3.36%
calculation in field is:1-([CycleGA])/([TaktTimecal]), because I need to
see
what the over/under percentage is
[CycleGa] is number entered by user 1.49 on form
[TaktTimecal] is calculated in the query
[MinutesPerShift]/[VehiclesPerShift]*[Uptime]
[MinutesPerShift] is entered by user (430), [VehiclesPerShift] is
calculated
in query (265), [Uptime] is entered by user (.95). The Takt TimeCal comes
to
1.54
I tried changing everything to currency, no luck there and have been
Googling and checking this forum for a solution.
I am completely self taught so its probably something really obvious.
Waiting with my fingers crossed
CAMI Lady
Click to expand...
Click to expand...
 
Back
Top