Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The numbers are different by fractional amounts. Use the Round function like, Round(Paid2,.01). See the QVW
The numbers are different by fractional amounts. Use the Round function like, Round(Paid2,.01). See the QVW
Thanks Jwjackso, this worked now.
🙂
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
Very interesting, thank you very much Brett