Hey all,
I have run into an issue using AggregateExpressions with GridViewSummaryItems.
If I use the following method and Sum(Foo2) is 0, I will obviously get a Divide by Zero exception. Is there anyway handle this when using AggregateExpressions or will I have to use the CustomSummaryItem method as described
here?
Dim summaryItem As New GridViewSummaryItem()
summaryItem.Name = "Foo"
summaryItem.AggregateExpression = "(Sum(Foo) / Sum(Foo2)"
Too clarify, I have already got the desired output (percentage of the sums of two other columns in my grid) using the CustomSummaryItem, but I would rather use AggregateExpressions if possible as it's cleaner and requires less code.
Thanks!