Type for big number (amount) like the income?

I have a question where we ask the income (turnover) to the enterprise. This amount can be exced twelve digit. For example 123 456 789 000. The type NUMERIC is limited at ten digit.
How we can resolve this problem?
I think to use the type TEXT and use the validation condition to test if the amount writed is a number!

Finally, I use TEXT as the type of the question and in the condition of validation, I use this syntax
!string.IsNullOrEmpty(self) && self.All(Char.IsDigit)


Another approach:

Q1: What is the turnover of this enterprise in the last fiscal year, (in mln USD)? (numeric)
A1: 123 457

Also make sure the question includes currency (if not obvious), unit, and reference period.

1 Like

Thanks for sharing this interesting validation, it is new in my knowledge dictionary.

Be careful with that!
Test with the following characters: โ€˜เนโ€™ โ€˜เน‘โ€™ โ€˜เน’โ€™ โ€˜เน“โ€™ โ€˜เน”โ€™ โ€˜เน•โ€™ โ€˜เน–โ€™ โ€˜เน—โ€™ โ€˜เน˜โ€™ โ€˜เน™โ€™
For example: เน‘เน˜เน‘เน˜เน˜
Or, similarly: ูงูฃูฃูงูง

So, perhaps, it is more robust to stay with the old friend:

1 Like