display data with '%' sign for a synthetic dimension

[sonikajain]

Hi all,

I am stuck in a scenario where the pivot table is created from synthic dimensions using VALUELIST, lets say - A,B,C,D,E,F are the dimensions amongst which, the B is calculated as a percentage. So, I need a way to display '%' sign for a single dimension created synthetically.

dimensions	utilization
A	12
B	67%
C	87
D	35
E	48
F	78

Code at the background -

if(ValueList('A','B','C','D','E','F')='A',sum({$<Division={A}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={B}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={C}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={D}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={E}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={F}>}BALANCE)))))))

Please help.

Thanks in advance

[Nicole-Smith · Accepted solution]

You just need to add a slight change to your code:

if(ValueList('A','B','C','D','E','F')='A',sum({$<Division={A}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',Num(sum({$<Division={B}>}BALANCE),'#,##0%'),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={C}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={D}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={E}>}BALANCE),

if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={F}>}BALANCE)))))))

This will display only B as a percentage.

[sonikajain]

thanks..it worked..!!