I have an issue with the formula in the ID field not displaying correctly as it has several decimal places even though the column it’s getting the data from is set to currency integer (2). How do I get it to display correctly?
This is how it’s showing:
This is my formula for calculating the Amount Outstanding:
And the format:
And this is my formula for the ID field:
Anyone know a way to fix this?