Hi @Analyst_SQL ,
According to the code and the image you provided, I found that there are two Total columns (S.total and Total) in the GridView.
<asp:TemplateField HeaderText="S.Total">
<asp:Label ID="lbltotalDisc" runat="server" Text=""></asp:Label>
<asp:TemplateField HeaderText="Total">
<asp:Label ID="lbltotal" runat="server" Text='<%# Eval("lbltotal") %>'></asp:Label>
And their IDs all contain ‘lbltotal’, and the selector in javascript is $("[id*=lbltotal]"), so the data in these two columns will be summed. I think this should be the cause of the problem.
I recommend that you could delete one of these two columns in the GridView. This will not cause confusion and will solve your current problem.
Best regards,
Xudong Peng
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.