Compare two Amount

[Ekta]

Dear All, 

I would like to know the formula to compare two amounts with +-1 difference ,

Amount 1      333,333.60

Amount 2       333,333.42

On comparing both Amount , output should be true.

Thanks in advance

[T_Willins]

Hi @Ekta,

If you get the amounts side by side, then using the formula ABS([Amount 1] - [Amount 2]) <= 1 with a field type of 'Bool' will give you the required results.