Pro exercise

A total of nothing is zero

Report March refunds as one row: how many and how much. Some months have no refunds at all. SQL's SUM over no rows is NULL, not 0, so the dashboard would show a blank instead of 'no refunds'. The total of nothing is 0.00.

• aggregation
• nulls
• KPIs

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.