I have a number field that is unable to have more than 2 decimals. This is the following customization I have for the field:
Data Type: Number
Language: English
Content Settings: General
Any Value, Allow more than 2 digits in fractional part
There are no rules, or custom actions on the field. I have tried adding a normalization to be able to allow it to have up to 4 decimal places but this also doesn't work.
Does anyone know how to fix this?
An example would be a number like 1.089 or 2.7654
Thanks!
The Field Value is Ambiguous: integer or real. (Error)
- 13 Views
- Last Post 3 days ago
ElliotG
posted this
5 days ago
MikeD
posted this
3 days ago
- Last edited 3 days ago
This is could be the result of three places after the decimal and the types of separators you are allowing with normalization. "1.089" COULD be "One Point Zero Eight Nine" or it COULD be "One Thousand and Eighty Nine". In other words the software can't distinguish one possibility from the other and so it warns you about it. If you can't overcome it by changing your normalization settings; specifically the "Digit Grouping Symbol" and the "Decimal Symbol", then the only other option is to try and address it with script/code which can get tricky.
ElliotG
posted this
3 days ago
Thanks! I will play around with this, I had a feeling it was due to the normalization. Will let you know what I come up with.
Categories
Search
This Weeks High Earners
-
Michaelfat 2
-
DGTDUYH 2
-
DFSYH 2
-
FDHDJ 2
-
XDGHFDJ 2
-
edtfreuyrt 2
-
gjgk 2
-
fcgj 2
-
xdghgfj 2
-
dzxgfgj 2