I have a query that does some calculations and stores the results in a table field defined as Fixed with 2 decimal positions.
When I display the table field it shows 2 decimal positions, but if I look at how the data is actually stored or export it to Excel it's stored with as many decimal positions as were in the result.
So if the result was 99.1191111 it shows me 99.12, but if I export it it exports 99.1191111 to Excel.
Is there any way to change the data in that table to actually store it as 2 decimal positions rounded?