% Text format => 100% but 95,25% if less

[#1]

Hi,

I'd like to format some percentages in text boxes on my dashboard in the following way:

if it's 100% => 100% (full integer)

if it's 0% => 0% (full integer)

if different => 95,25% (doubles with 2 decimals)

but now I only achieve the one or the other with '#.##0,00%'.

Is it possible?

[sunilkumarqv]

can you provide sample Doc

[MK_QSL]

IF(YourExpression=1 or YourExpression=0,NUM(YourExpression,'#0'),NUM(YourExpression,'#0.00%'))

[SergeyMak]

It's possible. Use the following expression

IF(Sum(Filed)=1 OR Sum(Filed)=0, Num(Sum(Filed),'#,##0%'), Num(Sum(Filed),'#,##0.00%') )

[marcus_sommer · Accepted solution]

Try something like this:

num(0.9525, if(frac(0.9525) = 0, '0%','0,00%'))

- Marcus

[#6]

Then I guess the frac() option is slightly more maintenance proof.

Thanks.