2 Replies Latest reply: Jul 27, 2011 4:48 AM by Deepak Vadithala RSS

    *** Need help with Aggr() Expression ***

    Deepak Vadithala

      Dear All,

       

      I am stuck with an expression which works fine when I filter the data and it gives incorrect numbers when I dont filter the data. Here is the expression...

       

      Dimension :

      ParentID

       

      Expression :

      SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId))


      This works fine, when I filter on the Field ParentID (Which is my only dimension). However, if I dont filter on the ParentID it gives incorrect numbers. I am not sure where is the problem. Unfortunately I cant load the QV document because it contains sensitive information. Can someone please help...?

       

      Thanks a ton in advance.

       

      Cheers - DV