% in pivot table

[upaliwije]

Hi Friends

I have following Expression in my Pivot Table

if(ValueList('Renewal Base','JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC','Renewed','Ren Base','Renewal %','%')='%',
num(SUM({<RN_TYPE={'RD'},RN_YYMM={'2018-01','2018-02','2018-03','2018-04','2018-05','2018-06','2018-07','2018-08','2018-09','2018-10','2018-11','2018-12'},MONTH={'JAN'}>}NOS)/SUM({<RN_TYPE={'RB'},RN_YYMM={'2018-00'},MONTH={'JAN'}>}NOS),'0.0%')

I want to show the value in in % format eg: 59.7%

. But in my pivot table it shows as a single digit . Pls help me to get it corrected

In my pivot table it shows as follows

[agigliotti]

maybe this:

'#,##0.0%'

I hope it can help.

[upaliwije]

Thanks

It is still the same 

[agigliotti]

how is the number format settings for your expression ?

[upaliwije]

[agigliotti]

let's try using "Expression Default" as format settings.

[upaliwije]

Then It works  but  format of others also change. There are some more expression connected with my Value list Command.

[agigliotti · Accepted solution]

you should apply the num function to all expressions.