Expand my Community achievements bar.

SOLVED

Display data - how to pattern to display to nearest 0.01%?

Avatar

Former Community Member

I'm trying to get a calculated value to display to the nearest 0.01%.  The forumla is simple:  288/12237 = 2.35%.  However, when I set the data pattern to any of the percent options, the only number the calculation returns is 2%.  How can I get the value to return as 2.35%?

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

use this display pattern:

num{z,zzz,zz9.99 '%'}

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi,

use this display pattern:

num{z,zzz,zz9.99 '%'}

Avatar

Former Community Member

Works for what I intend, although I did have to add a multiplication factor of 100 to the result.  Thanks.