Determining the output format of an expression

[#1]

I am using a dynamic footnote for one of my KPI boxes. The results of the function I use is a decimal out to 13 places past the decimal. I would like it to be a percentage but not sure how to script that format requirement within the function.

The function I am using is:

'% of Total Requests ' &Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME)

[ogster1974]

'% of Total Requests ' & NUM(((Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME))*100,'#,##0') & '%'

Should sort it.

[sasiparupudi1]

try

'% of Total Requests ' &num(Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME),'# ##0.00%')

[#4]

Thank you gentlemen, between the both of you I have it. Both of your solutions gave me an "error in expression" saying "Error in set modifier expression".

However, I combined both of your solutions to come up with this, and it worked:

'Percentage of Total Requests  '  &Num((Count({$<SUPPORTTEAM={'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME)*100),'#,##0.0') &' %'

Thanks again

[sasiparupudi1]

Glad to know that you could solve your issue. May I suggest to please close this thread by marking a correct answer so that it would be beneficial for others?

Thanks

Sasi