Condition Less Than not working for two columns formatted as currency in Sharepoint

[Anonymous]

Hello

So basically im trying to compare two columns with currency values from my sharepoint:

Column A 

Column B         

Im trying this condition which seems pretty simple to me. Is Yes, this is supposed to send an email.

However, my email is not being send since I get this error on my condition

Any idea on who i could fix this? 

Thank you

[DamoBird365 · Accepted solution]

Hi @Anonymous 

Your 2nd value is returned as a string.  You can try wrapping it in float() but if there are characters included, you might need to replace/remove them first in order to compare two floats.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

[Anonymous]

Wow that was so much easier than I expected, it is now working great. Thanks a lot !