Problem with number formatting of result on a calculated field


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.

Hi @agnes.farias

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: