Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I found number format error in my file.
Data in database (format numeric) : 10000.00000, 150.00000, 70.00000 <-- '." is decimal format
I'd set thousand and decimal separator format on edit script.
SET ThousandSep=',';
SET DecimalSep='.';
After reload I get wrong number.
10000.00000 should be 10.000, but the number become 1.000.000.000
150.00000 should be 105, but the number become 15.000.000
70.00000 should be 70, but the number become 7.000.000
how to solve this error? This is because the separator problem?
Thanks before.
Regards,
Heri
Could very well be a separator problem.
Itsangad's suggestion is a good way to check what you really have loaded, but it will not solve you problem if there is a problem. To solve it you may need to use the Num#() function to interpret it correctly, e.g.
Num#( Field, '#', '.', ',') as InterpretedField
HIC
can u upload the sample app or data?
Hello Heri,
After you reload, you go to Number Tab of your Listbox or chart to change its format.(Use Interger format)
Or to check the default format, you can check on Document Properties->Number tab.
Please let me know if this was helpful, or anything else is required.
thanks,
itangad
Could very well be a separator problem.
Itsangad's suggestion is a good way to check what you really have loaded, but it will not solve you problem if there is a problem. To solve it you may need to use the Num#() function to interpret it correctly, e.g.
Num#( Field, '#', '.', ',') as InterpretedField
HIC
Thanks Henric and Itangad for your solution
I think its because of the Regional location setting on computer. After I change to my region (Indonesia) and try to reload again, the problem is solve.
Thanks.
Regards,
Heri