The total can be calculated through the Aggregate function Sum
. However, for each value, you need to check the type and if it is a number to convert it to double
. The expression might look like:
="Total: " + Sum(CDbl(IIF(Fields.Type = 'number',Fields.Value, 0)))
The attached report demonstrates the solution. Keep in mind that a CSV data source
is used where the double values are separated by a dot (instead 5,21, 5.21 is used).
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal
and vote to affect the priority of the items