Skip to Content
0
Former Member
Oct 27, 2005 at 01:16 AM

BW Report - Rounding Quantities

847 Views

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