0VALSTCKQTY inventory keyfigure rounds up/down? With NODIM, it displays correct value?

[Loed]

Hi,

Just want to ask why 0VALSTCKQTY keyfigure rounds up/down? But when using the NODIM function it displays the decimal values? The 5th column has the NODIM function.

Thanks.

Loed

[rodolfo_bermudezneubauer3 · Accepted solution]

Hi,

BW Quantity key figures are displayed according to the number of decimal places configured for each Unit of Measure (as are Currency key figures). If you set the query to display more decimal places than those set for the UOM (or Currency), you will get the rounding effect you have shown. From your query results it looks like “SL” UOM has 0 decimal places. The NODIM function removes the associated UOM from the Quantity Key Figure and thus changes this behavior (values are displayed as stored in the Database with no associated UOM).

Regards

[Loed · Accepted solution]

Thanks a lot for the help Rodolfo.

Loed