3 Replies Latest reply on Feb 14, 2018 1:09 PM by Deepak Rai

    Grand Total(Avg) Changes based on grouping method

    Sam Fregly

      Can someone please explain this phenomenon to me.

       

      Here are the values of a single account on dates that trades were made. If I group the networth of the account on the individual days I get an average of 49k, but if i remove the date column and only group it by the account number I get a completely different value. The removal of trans_dt is the only change i am making. In fact the value I get when i remove the date is lower than minimum value of that account across the entire date range.

       

      ------->>>>>>

       

      Can anyone explain what is going on and how to fix it.