Hello
I have query returning decimal values. The decimals are shown in the datasheet view of the query, but are rounded when I look at pivot table and chart view.
Changing the data type in the query to a currency shows the two decimal places, but they are also rounded and only show zeros.
I read somewhere that this is a bug and must be fixed with code?
I have query returning decimal values. The decimals are shown in the datasheet view of the query, but are rounded when I look at pivot table and chart view.
Changing the data type in the query to a currency shows the two decimal places, but they are also rounded and only show zeros.
I read somewhere that this is a bug and must be fixed with code?