string-length() for decimal questions is unreliable

159
0
02-27-2024 09:11 AM
abureaux
MVP Regular Contributor

So I was trying to troubleshoot something, and I noticed that string-length for decimal questions stopped behaving as expected for longer numbers.

Here was my set-up:

abureaux_2-1709052043246.png

And results:

abureaux_7-1709052196796.png

abureaux_8-1709052204304.png

At a certain point, string-length() stops working properly on decimal fields. It's misleading, because it does work for smaller character counts, but then stops working around 15ish characters.

  • All "1" breaks at 22 characters
  • All "9" breaks at 15 characters

I thought, "well, convert decimal to string and problem solved?". Nope. In this example, I first convert the value to a string:

abureaux_10-1709052395823.png

 

abureaux_9-1709052364044.png

 

0 Replies