[Solved] total in the footer with GridNumericColumn

[newbie]

I am using the Aggregate="Sum" property of the GridNumericColumn to display the sum of the column in the footer.
The total is displayed as 'Sum: x'
Is it possible to remove the word sum from the display?

[Suresh]

Hi,
 
you can set like,

 Aggregate="Sum"    FooterAggregateFormatString

="{0:N}"

hopes this helps

[newbie]

that works.

Thanks!

[Ron]

Hi I have a similar issue. I have the following code and my total line shows  custom: $800 I would like to see the FooterText as filled in.

Any help is apriciated.
Ron

 

 

<telerik:GridBoundColumn ColumnEditorID="TOTAAL" DataField="TOTAAL" HeaderText="Totaal" FooterText="Totaal te Factureren"

 

 

 

MaxLength="30" UniqueName="TOTAAL" DataType="System.Decimal" Aggregate="Sum"

 

 

 

DataFormatString="{0:c}" FooterAggregateFormatString="{0:c}" >

 

 

 

<FooterStyle Font-Bold="True" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"

 

 

 

Font-Underline="False" HorizontalAlign="Right" Wrap="True" Width="75px" />

 

 

 

<HeaderStyle Wrap="True" Width="75px" Font-Bold="True" Font-Italic="False" Font-Overline="False"

 

 

 

Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Right" />

 

 

 

<ItemStyle Width="75px" Font-Bold="False" Font-Italic="False" Font-Overline="False"

 

 

 

Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Right" Wrap="True" />

 

 

 

</telerik:GridBoundColumn>

 

[Princy]

Hello Ron,

You can try out the following code to set a custom footer text along with the aggregate value for a column:
c#:

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridFooterItem)
        {
            GridFooterItem footer = (GridFooterItem)e.Item;
            string strTotal = footer["TOTAAL"].Text;
            footer["TOTAAL"].Text = "Totaal te Factureren :" + strTotal;
        }
    }

Thanks
Princy.