[Solved] Gridview sum format

[Rama]

Hi,

I'm using the following format for displaying value:

gridColumn.AggregateFunctions.Add(new SumFunction() { SourceField = string.Format("DataPoints[{0}]", measure), Caption = "Sum:", ResultFormatString = "{}{#.##}", SourceFieldType = Type.GetType("System.Double") });

I would like to use just 2 decimal places but I'm not sure what's being used under the hood!  It never brings any value!

for e.g if the sum is 23333.567899 then I would like to display 23333.56 or 23333.57

Thanks,Rama

[Maya]

Hi Rama,

You may define the aggregate function as follows:

GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("Number");
column.AggregateFunctions.Add(new SumFunction() { Caption = "Sum: ", ResultFormatString = "{0:#.##}"});

 

Greetings,
Maya
the Telerik team