### Title

Subsummary Report w/Percentages

### Post

Hi all,

How do I get the percentage columns to not display the ? mark when the result is zero? Also, I would like to get the quarterly percentages to total. For example the quarterly total for Q1 should be 100 and Q4 should be 67 and the yearly should be 43. See attachment.

Thanks, Emmett

What's the calculation you are using to compute a percentage? On trick is to include an If function that returns 0 of the divisor is empty or zero instead of the percent calculation.