I am using the summary row to display an average of several percentages. However, if one of the cells contains an "empty" value, the average calculation stops working. I can't set these to 0% because that would skew the calculation. Empty values should not be included in the average calculation.
Empty item in column:
Without empty item:
Is there a way to make this work?
My fallback plan is to write a transformer and manually add a summary row, but an out-of-the-box solution would be much nicer