Forum Discussion
Solved
Comparing two columns in a table...
Hi All Trying to create a table that compares two column values and returns a value where there is a match ('Balanced' or 'Imbalanced'). I know I've done it correctly as its working in most...
it's probably rounding issues, you can add ROUND() to your comparison to cut of at the same precision to solve it
it's probably rounding issues, you can add ROUND() to your comparison to cut of at the same precision to solve it
Aaah! I didn't think that was the issue but playing around with the forumula and then eventually switching the data type of the two currency cells to 'Fixed Decimal..' seems to have eliminated any formatting/ rounding issues! (if that's what it does)
Merci Beaucoup! :smileylol:
