BASES - Custom Summary

Setup

• Right-click a column header and choose “Summarize”
• Click “Add summary” to use a custom formula
• The default average includes blanks; this formula excludes them

Code

(values.sum() / values.filter(value.toString().trim() != "null").length).round(1)

Source

• Obsidian Bases Made Simple - Advanced Tips
• See it in action: YouTube