BUG in formula calculation

BUG in formula calculation

I have a personalized formula field that returns a string of the following type:

If( (Math Operation) > 1000000, 'True', 'False')

The math operation involves several fields, some of them converted from string to number using the Tonumber() function. The problem is that the Math Operation resolves to a very low number, say, 5, so the resulting string should be 'False', as the condition is never met.

HOWEVER, the formula field always returns 'True'.

I know the Math Operation is correct and resolves to a very low number, since I have exactly the same operation in another field showing the correct result. In other words, the Math Operation is correct and debugged. Zoho is mangling the result when handling the data types.

If I use a straight operation in the formula of the type If( 1 > 2, 'True', 'False'), the result is a correct 'False', but if I use a math operation instead of the 1, the result is incorrect.

Can you guys help with this? I need to finish a module to launch a service in the next few days.

Thanks a lot in advance.