5 Replies Latest reply: Apr 13, 2015 8:53 AM by Viktor Petrov

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

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?

• ###### Re: % Text format => 100% but 95,25% if less

can you provide sample Doc

• ###### Re: % Text format => 100% but 95,25% if less

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

• ###### Re: % Text format => 100% but 95,25% if less

It's possible. Use the following expression

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

• ###### Re: % Text format => 100% but 95,25% if less

Try something like this:

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

- Marcus

• ###### Re: % Text format => 100% but 95,25% if less

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

Thanks.