6 Replies Latest reply: Nov 15, 2012 2:57 AM by jagan mohan rao appala RSS

    Usage of Aggregation

      Hi,

       

      I have below mention expression and I want to convert to aggregation expression, reason behind converting into aggregration expression because I have multiple dimention and in each dimention I want total but with below mention expression it is limted to only VOUCHERNO.

       

       

      I have below mention dimention on my piovt chart :

       

      BRANCH_CODE,

      YEAR,

      QUARTER,

      MONTH,

      ITEMTYPE,

      VOCHERDATE ,

      VOCHERNO,

      STOCKCATEGORY,

      STOCKCODE

       

      -------------------------------------------------------------------------

      (

      (sum(DISCOUNTCC))

      *

      (

      (sum(SALESPRICE))

      /

      (sum(TOTAL<VOCHERNO>SALESPRICE))

      *100

      )

      /100

      )

      --------------------------------------------------------------------------

       

      I had tried to below mention expression but i did not get any result but not sure why

       

      -------------------------------------------------------------------------

      aggr(

      (sum(DISCOUNTCC))

      *

      (

      (sum(SALESPRICE))

      /

      (sum(TOTAL<VOCHERNO>SALESPRICE))

      *100

      )

      /100

      ,BRANCH_CODE,YEAR,QUARTER,MONTH,ITEMTYPE,VOCHERDATE,VOCHERNO,STOCKCATEGORY,STOCKCODE

      )

      --------------------------------------------------------------------------

       

      So any idea why ?