1 Reply Latest reply: Jun 30, 2016 5:32 AM by PAUL YEO RSS

    Why sum(sales)/Rate not equal to sum(sales/Rate) ?

    PAUL YEO

       

      Hi All

       

       

      I think sum(sales)/Rate is equal to sum(sales/Rate)

       

       

      I have a expression work fine :-

       

       

      sum({$<BRAND_SUB={"PROJECT"}>} sales/Rate)

      /

      SUM(sales/Rate)

       

       

      But the below expression is not correct :-

       

       

      sum({$<BRAND_SUB={"PROJECT"}>} sales)/Rate

      /

      SUM(sales)/Rate

       

       

      Can some one share with me why ?

       

       

      PAul