Skip to Content
0
Former Member
Feb 25, 2010 at 05:50 AM

Do not round off decimal places for a key figure

88 Views

Hi All,

I have a requirement where the users want the decimal places of a particular key figure to be 3.

I set the decimal places to 3 in the Query Designer.

The users now want that the decimal places shouldn't get rounded off.

e.g. The key figure value is 10.65468.

Then in this case, the decimals should be truncated to 3 places, ie. 10.654;

whereas by using the decimal places option in the query designer, the value displayed for 3 decimal places is 10.655.

Is it possible to truncate the decimal places so as to obtain 10.654 as the output ?

Kindly help....

Thanks in advance