on 08-27-2007 10:52 AM
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
Hi Ralph,
Use following formula.
NVAL(NSTR(24.190000,10.2))
Regards
Pramod Patil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.