Table Subtotals blank Values

[darenhunter]

• Goal: Have the table provide averages and sums on tables with blank values.

• Steps: If I replace nulls with 0 it works - but will not work with average.

Anyone know if the summary row can ignore blanks somehow?

[darenhunter]

As a follow up - it appears it does sometime do averages with empty rows?

[darenhunter]

Nevermind, I seemed to have fixed it using || null

for example, putting {{ item || null }} seems to make it work