contains(format(prop("Number")), ".") ? length(replace(prop("Number"), "^([^.]+.)", "")) : 0
contains(format(prop("Number")), ".")
Check to see if Number contains a period.
? length(replace(prop("Number"), "^([^.]+.)", ""))
If it does, first replace all characters up to and including the period with nothing and then calculate the length of the remaining digits.
: 0
If Number doesn't contain a period, display 0.
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>
