Formatting question

[jymm]

I have a matrix where I show a numeric field that has a format of N0 (as in N zero). This works great as when the value is actually 0 we see blanks in the matrix which is the desired behavior.

I have another field that is a percentage which is formatted as P0 (as in P zero). Again - works great ... except when the value IS zero and the format still puts out the percent sign (so it would show ' %' in the matrix - no quotes).

prolly not a huge deal, but why would N0 not print anything when 0, but P0 still print the percent sign when the percent is 0... anyone got any ideas?

 

[andrea96]

I would guess it is because the percent sign is part of the formatting and not the actual number. You can hide the field when the value is 0, if you don't want the % to show.