Hi:
I have a report with a quantity field. When I view the quantity in the cube the value contains 3 decimals. However, when I run the query in Bex or Web, the quantity is rounded off and my decimals show as zero.
Example: Invoice Quantity = 168.650. the report will display 169.000. Invoice Quantity is define as a quantity; data type is Quan. Unit/currency is 0PO_Unit.
In the query, in the properties of Invoice Quantity I have set up as the following: Under "Number Format" - Scaling Factor is set to 1. "Number of Decimal Places" is set to 0.000. I don't understand why this is not working properly.
Does anybody have any ideas why it's rounding instead of showing the decimals?
Thanks in advance for your help!
Regards,
Helena