Topic: tablegrid footer not summing
Good Morning Dmitry and MVD Team,
I have set a tablegrid column footer to sum a column (suppliers.totvalords which is defined as a 'calculated' field type).
But if the cell value of suppliers.totvalords is blank, the column footer total also shows as blank (see screenshot dmitry - no totals 1.jpg).
To try and correct this, I then formatted the column on the tablegrid to display as 0 but the column footer total still shows blank (see screenshot dmitry -no totals 2.jpg).
If I delete the row that contains the suppliers.totvalords blank cell, the column footer total sums correctly.
Is there a way to fix this?
Thankyou,
Derek