The Field Value is Ambiguous: integer or real. (Error)

  • Last Post 2 days ago
ElliotG posted this 4 days ago

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


Order By: Standard | Newest | Votes
MikeD posted this 2 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 2 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.