cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with rounding values in table

Former Member
0 Kudos

Hello all,

I have a key figure Operating Income. For 003.2007 the value is 24.190.000. In my query I use a scaling factor 1000. When testing a query in Visual Composer the value is then shown as 24.190.

However, when executing the model I see value 24.19. Thus without the 0. How can I make sure the 0 is added?

Thanks in advance,

Ralph

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ralph,

Use following formula.

NVAL(NSTR(24.190000,10.2))

Regards

Pramod Patil

Former Member
0 Kudos

hi Ralph

In the Formatting tab of the field choose the number format as numeric and uncheck the Local format which will enable 3 other fields at bottom namely,

Decimal places -here you can specify the number of decimal spaces.

I hope this helps.

Regards

Navneet