supressing Zeros and Totaling Percentages

BLOMASKY

question 1: Is there an easy way to have zeros appear as blank fields. (realize that sometimes, the zero is a % and sometimes, has decimal places?

question 2: I have a grid column that is a pct. therefore, to display it with the % sign, the number is .01 the value. i.e. 0.10 will display as 10% if I have a pct sign. All is good, but I want the MAX of the column and that is displayed as a decimal. (displays .46 instead of 46% How can I fix this.

thanks

Bruce

tford

question 1: Is there an easy way to have zeros appear as blank fields. (realize that sometimes, the zero is a % and sometimes, has decimal places?

I often use conditional formatting to accomplish this. Just use a white font when the value is zero.

BLOMASKY

Tom, the only problem with that is on a grid where alternating rows are colored differently.

bruce

tford

Bruce,

Came across this old post and used this approach to "blank when zero" today:
https://forum.awareim.com/d/164