Radgrid Row Summary Error

[Purojit]

Hi,

 I am  showing bill register in RADGRID. However if a customer has bought more than one item, then I am adding Bill Total in the "B.AMT"  column. But the problem is ,while doing column summary, the bill total is counted as per number of items in case there are more than one item bought by customer. Please find in the attached screenshot.
Here Gopal TODI has bought 2 items  of total amt. 66778. But while calculating the summary of B.AMT ,66778 is added twice.

Please look into this.

Regards
Purojit

[Alex]

Why don't you use "Aggregate" property from GridBoundColumn.

[Princy]

Hi Purojit,

Please check the following demos,i am not sure how you are adding the values .If these links didn't help,please provide your code.
Grid - Footer Aggregates
Grid - Calculated Columns

Thanks,
Princy

[Purojit]

Hi Princy,

Thanks for your reply. But these links are not helpful. Please read our post carefully and check the snap, I hope you will understand.

Thanks
Purojit

[Princy]

HI Purojit,

Please try the following code snippet.I have attached the screenshot of what i obtained.Please let me know if any concern.

ASPX:

<telerik:RadGrid ID="Radgrid1" runat="server" DataSourceID="SqlDataSource1" ShowFooter="true">
    <MasterTableView AutoGenerateColumns="false" DataSourceID="SqlDataSource1">
        <Columns>
            <telerik:GridBoundColumn DataField="OrderID" HeaderText="OrderID" UniqueName="OrderID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Quantity" HeaderText="Quantity" UniqueName="Quantity">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="UnitPrice" HeaderText="UnitPrice" UniqueName="UnitPrice">
            </telerik:GridBoundColumn>
            <telerik:GridCalculatedColumn HeaderText="Total" UniqueName="TotalPrice" DataType="System.Double"
                DataFields="Quantity, UnitPrice" Expression="{0}*{1}" FooterText="Total : " Aggregate="Sum">
            </telerik:GridCalculatedColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

Thanks,
Princy