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 :



      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