Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
'% of Total Requests ' & NUM(((Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME))*100,'#,##0') & '%'
Should sort it.
try
'% of Total Requests ' &num(Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME),'# ##0.00%')
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
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