why is calculation is wrong

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
 
S

Steve C, MFS

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
 
B

Beetle

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
 
K

kc-mass

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
 
C

CAMI Lady

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...
 
Top