Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like
=num((Expression),'#,##0')
Are you looking 1,5 %??
yes
If possible please share workfile to test. OR Use #,0 %
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