The behaviour of the Total when there are 0 rows in the data source depends on the aggregate type and the Report.ConvertNulls setting:
ConvertNulls = false (default): Count returns 0, whilst the Sum, Min, Max and Avg aggregates return null or an empty string (they are not displayed as 0).
ConvertNulls = true: all five aggregates (Sum, Count, Min, Max, Avg) return 0.
If you require a consistent 0 when the table is empty without setting ConvertNulls = true globally, set ConvertNulls = true for a specific TextObject (or handle nulls in the expression: [[TotalName] ?? 0]).
Comments
Hello!
The behaviour of the Total when there are 0 rows in the data source depends on the aggregate type and the Report.ConvertNulls setting:
ConvertNulls = false (default): Count returns 0, whilst the Sum, Min, Max and Avg aggregates return null or an empty string (they are not displayed as 0).
ConvertNulls = true: all five aggregates (Sum, Count, Min, Max, Avg) return 0.
If you require a consistent 0 when the table is empty without setting ConvertNulls = true globally, set ConvertNulls = true for a specific TextObject (or handle nulls in the expression: [[TotalName] ?? 0]).