2. PHPRunner General questions
  3. decimal error
This topic is locked

decimal error

 		9/14/2021 7:43:39 PM
PHPRunner General questions
L
 luchoadmin author

Hello dears,

I have an error in phprunner and I don't know how to solve it.

I have a table that contains a field where 6 weighings are loaded from a scale. data is loaded with 3 decimal places. then phprunner should show an average of the 6 records. the average should be 16,633 but phprunner calculates it 16,630. Do you know how I can solve it? I tried to format it 3 decimal places, custom doing round, etc
img alt
.

regards
C
 		charlesfolder 9/14/2021

Check your regional settings

img alt

woodey2002 9/14/2021

When creading the field in the database did you define it as varchar or number etc. if so, maybe have a look back at the filed characteristics in the databse to adjust the precision of an existing decimal column to handel the decimal to see if that helps

Cheers,
J
L
 		luchoadmin author 9/15/2021

didn't work, some other idea. Thank you
admin 9/15/2021

You must explain what exactly did you try and what results you got. "Didn't work" won't get you very far.
L
 		luchoadmin author 9/16/2021

sorry, the field was in double and it was difficult to put double 6.4 and decimal 6.4 10.4 and it didn't work. Regarding the regional setting I put it and I do not modify it at all!
any other idea?