Forum Discussion
How to get original value( not rounded) in tabular
In the report I'm working with the 2 decimal number is rounded . For example 2,087 is rounded to 2.09 How can I change it in tabular Fact table so instead of 2.09 shows the original value 2.08?
To work around this problem, manually set the Field Size property of the column to Double or to Decimal.
Click the DataSheet tab. In the Views group, click the arrow under View, and then click Design View.
Note If the table has not already been saved, you will be prompted to save the table with a table name that you provide.
Locate the column that you want to change, and then set the Field Size property of the column to Double or to Decimal.