10 Replies Latest reply on Oct 16, 2017 11:46 AM by Paramvir Singh

    Unable to aggregate the Averages

    Paramvir Singh

      Hi,

       

      I am trying to aggregate the Weighted Average by Name in the attached workbook.

       

      The issue is that the Weighted Average is being calculated as (Running Sum of Amount)/Day Count for each subName. But when I need to total upto the Name, the aggregation does not work.

       

      For Example: In this screenshot below, the Weighted Average Column is being calculated correctly for each SubName. However, if I take out the SubName from the Rows, then the Weighted Average is not correct. It seems like there is some issue with the formula that I am using for calculating the Weighted Average (I have set up a custom calculated field for that). Any advise of sorting this out would be really helpful.