How to have a sum calculation include all amounts (even those filtered from view)

My simple sum(N8) is recalculates incorrectly if I filter out rows,only including the rows not filtered out - and only then getting the sum if I add a new row to force a recalc of the formula.

I simply want the sum of the field to be displayed whether a row was filtered from view or not.

Can you help mi do this?

Hi,

Just to make sure, is N8 a subtable field?

Yes N8 is a subtable field

Hi,

There is currently an issue when formulas are applied to a filtered subtable field.
Our developers are working on this issue now, and we’ll get back to you when we have more details.