Do not round off decimal places for a key figure

[Former Member]

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

[former_member366279]

Hi Apeksha,

I suggest you to try a formula like this:

formula = TRUNC(key figure * 1000)/1000

I tried this and it works well

Regards,

Patricia