Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why wont Paradox give me the correct answer from a divide formula

Status
Not open for further replies.

woodyinoz

IS-IT--Management
Jan 8, 2002
215
GB
Hi all,

The following formula should give me the answer 36.25 However, when running the formula I get 36.00 as my answer.

SawTime = 7.5/TotQuant + 10/TotQuant + 10 + NHG + 4 + 5 + 2.5

I have checked the format of the fields on the form and they are all set to accept 2 decimal places. Is there anything I can try to get the correct answer?

Thanks,

Woody

 
I suspect the problem is associated with the type of
SawTime, TotQuant or NHG. (The parser sometimes casts the answer depending on the type of the first variable it comes accross.) If not a type problem, then it is a display issue.
The following should definitely work, assuming SawTime is a Number type:

SawTime = 7.5/number(TotQuant) + 10.0/number(TotQuant) + 10.0 + number(NHG) + 4.0 + 5.0 + 2.5

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top