Number format for showing value in %

[#1]

Hi All,

I am using the below formula in a text box to calculate the rate. 

=

num((count({$<[Lead Date]= {Yes}, [Opportunity Date]={Yes}>} [Id]) / count({$<[Lead Date]= {Yes}>} [Id])) * 100,'#,##0.00%')

I am getting the value as 10.000.00% I want to show it as 100%. I have tried some other format also but it's not working.

Please suggest.

Thanks

Ashish

[robert_mika]

Could you post your app?

[fvelascog72 · Accepted solution]

Try this:

num((count({$<[Lead Date]= {Yes}, [Opportunity Date]={Yes}>} [Id]) / count({$<[Lead Date]= {Yes}>} [Id])) ,'#,##0%')

[#4]

Try like below,

=

num((count({$<[Lead Date]= {Yes}, [Opportunity Date]={Yes}>} [Id]) / count({$<[Lead Date]= {Yes}>} [Id])) * 100,'#.##0%')

[#5]

Thanks Federico..