One decimal

[danialier]

Hello,

What else do I need to add to this formula so it only shows ONE decimal ?

  =((num(sum({<Period={'Feb'},BA={'Net Revenues'}>}Amount)/1000))/
    (num(sum({<Period={'Jan'},BA={'Net Revenues'}>}Amount)/1000))-1)*100

thks,dani

[maxgro]

=num(1/3, '#.##0,0')

EDIT: or go here (tablebox, chart) to choose format

[Anonymous]

just use the "round" funtion...for ex; round(3.88, 0, 1) = 3,9

[its_anandrjs · Accepted solution]

Hi,

Try like this

=num( ((num(sum({<Period={'Feb'},BA={'Net Revenues'}>}Amount)/1000))/
    (num(sum({<Period={'Jan'},BA={'Net Revenues'}>}Amount)/1000))-1)*100,'#,##0.0')

Hope this helps

Thanks & Regards

[preminqlik]

num(expression,'#.#')

or else go to number format tab and you can do over there

[MK_QSL]

NUM(yourexpression, '#,##0.0')

[#7]

In addition:

Note that it is related to the setting of your decimal separator:

This is a setting that normally is set on the Main tab of your loadscript:   

SET DecimalSep=',';

So when this value is a comma (like above) then this is correct

=num(1/3, '#.##0,0')

When it is a dot (like below)

SET DecimalSep='.';

=num(1/3, '#.##0.0')

is correct

[its_anandrjs]

Hi,

Check your decimal separator is and according to separator change comma or decimal in this script '#,##0.0'

=num( ((num(sum({<Period={'Feb'},BA={'Net Revenues'}>}Amount)/1000))/
    (num(sum({<Period={'Jan'},BA={'Net Revenues'}>}Amount)/1000))-1)*100,'#,##0.0')

Otherwise change is Properties -> Number -> change fixed to upto 1 decimal place.

Hope this helps

Thanks & Regards