Hello!
When trying to compare a numerical value with the number-formatted result of a calculated field in a search action, I’m not getting any results. However, when I change the calculated field to display the result as text and then compare it to the numerical value, it shows the results. This is strange because when I go directly to the app and filter using the number-formatted result of the calculated field compared to a number, it works just fine.
I know this is not exactly what you mean but hopefully it is similar:
A calculation generating a number:
An automation searching for the number:
doesn’t match the record?
I think this is a bug @Tim
If I put the search in a script:
It finds the record, however, if I convert the search to a script I believe that the script is incorrect:
To solve this I always use the text formatting of value if it’s a field I have to compare… But it’s still very strange.
