Summary row doesn't work with empty values

Hello everyone,

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:
Screenshot 2024-01-24 at 10.19.32

Without empty item:
Screenshot 2024-01-24 at 10.19.32

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 :slight_smile: