2 Replies Latest reply: May 3, 2012 8:48 AM by Sonika Jain

# display data with '%' sign for a synthetic dimension

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)))))))

• ###### display data with '%' sign for a synthetic dimension

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.

• ###### display data with '%' sign for a synthetic dimension

thanks..it worked..!!