2 Replies Latest reply: May 2, 2013 10:29 AM by Sukhwant Matharoo RSS

    expression issue

    Sukhwant Matharoo

      hi

      below is my table

       

      id          value          tradepurpose     date    

      1               100               abc              T

      1               150               xyz               T-1

       

      i have created a straight table and the expression is not working properly:

       

      D          D                      Expression                         Expression

      id          tradepurpose        T value                              Change %

      1                                    sum({<date=T>}value)          alt(sum({<date=T>}value) /sum({<date=T-1>}value)-1,1)

       

      answer i am getting is below:

      id          tradepurpose          T value          Change %

      1               abc                         100          100%

      1               xyz                         0               -100%

       

       

      i want the answer to be: (is it possible having trade purpose in the dimension

      id           tradepurpose          T Value          Change %

      1               abc                         100               -33%

       

       

      thanks