I can't seem how to figure out how to get correct decimal values in my footer aggregate using Avg as the aggregate method. Here is the column for the aggregate
The values that are being averaged are 24, 10, 7, 14. The average comes out as 13.00 when it should come out as 13.75. If I change the FooterAggregateFormatString="Avg: {0:0.00}" to FooterAggregateFormatString="Avg: {0:0}", it rounds down to 13 instead of up to 14.
Can you tell me how to get an accurate average using this method. Thanks.
<telerik:GridBoundColumn Aggregate="Avg" FooterAggregateFormatString="Avg: {0:0.00}" DataFormatString="{0:0}" HeaderText="Age" HeaderStyle-Wrap="false" UniqueName="age" DataField="age" SortExpression="age" Groupable="false"> |
<ItemStyle Wrap="false" /> |
</telerik:GridBoundColumn> |
The values that are being averaged are 24, 10, 7, 14. The average comes out as 13.00 when it should come out as 13.75. If I change the FooterAggregateFormatString="Avg: {0:0.00}" to FooterAggregateFormatString="Avg: {0:0}", it rounds down to 13 instead of up to 14.
Can you tell me how to get an accurate average using this method. Thanks.