topic Re: % in pivot table in App Development

% in pivot table

upaliwije — Thu, 06 Dec 2018 08:34:21 GMT

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

Re: % in pivot table

agigliotti — Thu, 06 Dec 2018 08:57:15 GMT

maybe this:

'#,##0.0%'

I hope it can help.

Re: % in pivot table

upaliwije — Thu, 06 Dec 2018 09:26:58 GMT

Thanks

It is still the same

Re: % in pivot table

agigliotti — Thu, 06 Dec 2018 09:55:01 GMT

how is the number format settings for your expression ?

Re: % in pivot table

upaliwije — Thu, 06 Dec 2018 10:42:47 GMT

Re: % in pivot table

agigliotti — Thu, 06 Dec 2018 11:03:26 GMT

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

Re: % in pivot table

upaliwije — Thu, 06 Dec 2018 11:41:42 GMT

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

Re: % in pivot table

agigliotti — Thu, 06 Dec 2018 12:09:20 GMT

you should apply the num function to all expressions.