formatting numbers

[master_student]

Hello Guys,

I have an expression that return a value with exponentielle :

here is th expression :

=num(((sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA))

- (sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA)))

/sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA)*100,'# ## % ')

I need one number after the comma

How to correct it ?

Thanks

[prma7799]

Try like

=num((Expression),'#,##0')

[Anil_Babu_Samineni]

Are you looking 1,5 %??

[master_student]

yes

[Anil_Babu_Samineni]

If possible please share workfile to test. OR Use #,0 %

[pradosh_thakur]

try this

expression:

=num((((sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date]))},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA))

- (sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -= {'Shops'}>}MNT_DATA)))

/(sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL = >}RVN_AIRTIME) -sum({$<[Year of date]={$(=Max([Year of date])-1)},RVN_DATA_CHANNEL -=

{'Shops'}>}MNT_DATA)))*100,'#,## 0')

& '%'

regards

Pradosh