Comparative two columns

[olramirez]

Hello, 

I have a problem when i want to comparate two numeric columns in a straight table. The first expression column is Amount, the second one is Paid2 (Paid2 is the aggregation of Paid by document). If this two columns are equals then Right else No Right. This looks very simple but i haven't been able to make it  😞   I have tried two options Val and Val2

Thanks for your help.

Olga

[jwjackso · Accepted solution]

The numbers are different by fractional amounts.  Use the Round function like, Round(Paid2,.01).  See the QVW

[olramirez]

Thanks Jwjackso, this worked now.

🙂

[Brett_Bleess]

Just adding a Design Blog post on Rounding Errors to this one, just in case that may come into play for someone else.

https://community.qlik.com/t5/Qlik-Design-Blog/Rounding-Errors/ba-p/1468808

Regards,
Brett

[olramirez]

Very interesting, thank you very much Brett