6 Replies Latest reply on Oct 12, 2016 9:54 PM by Madhumitha Palanisamy

    Sub Total values are wrong for Table calculation

    Madhumitha Palanisamy

      Hi

      I have a table like this,

       

         

      IdDateSales
      101/03/162000
      102/04/16
      103/05/16
      104/06/16
      205/11/163000
      210/11/16
      210/20/16

       

      I want to add a new column by dividing the sales by count of same id (For Example 2000 by 4 and 3000 by 3) and need to fill the column.

      I can able to get a table like this,

       

         

      IdDateNew SalesSales
      101/03/165002000
      102/04/16500
      103/05/16500
      104/06/16500
      205/11/1610003000
      211/11/161000
      212/20/161000

       

       

      I have done this using the calculated field.

      But when I am displaying the month wise total for New Sales. It is showing as 500 for Id 1 and 1000 for Id 2 (i.e. the total is based on the first cell of the column). But for sales it shows correct total as 2000 and 3000.

         

      IdDateNew SalesSales
      101/03/165002000
      02/04/16500
      03/05/16500
      04/06/16500
      Total5002000
      205/11/1610003000
      11/11/161000
      12/20/161000
      Total10003000

       

      Please help me to solve this.