Round Percentage

[marco_puccetti]

Hello i need to round a percentage value from

nn.n1n2n3n4n5n6 to nn.n1 which function can i use?

The formula used is the following:

=num(count(distinct value1),'#,##0.##','.' , ',') / num(Count(distinct value2),'#,##0.##','.' , ',') * 100 & '%'

Thanks

Marco

[#2]

Do you just need the displayed format to be to 1 decimal place?

[avinashelite]

add this in num

'###,###,###.##0,00'

num(count(distinct value1),'#,##0.##0,00','.' , ',') / num(Count(distinct value2),'#,##0.##0,00','.' , ',') * 100 & '%'

Thanks

[marco_puccetti]

It doesn't work!

How can i force the 2 decimal value?

Thanks

Marco

[tresesco · Accepted solution]

Num(12.34567, '##.##') - for two possible decimal

Num(12.34567, '##.00') - for forced two decimal

[marco_puccetti]

Yes i've just tried with Num(123456.789789789,'##.##') and it works.

Thanks

Marco

[alex_millan]

Hi,

and perhaps you may want to force the desired format (two decimal values) on the division result

= num( ( [Expression A] / [Expression B] ) * 100, '##,00' ) & '%'

HTH

Regards