2 Replies Latest reply: Nov 9, 2017 5:44 AM by youssef belloum RSS

    how to write dynamic expression

    naveen kumar

      Hello All,

                   when the  expression is like below it is working(value=85 correct)

                                  Expression:

                                             sum({<SCOPE={'YES'},NUMBER={'030'}>}total VOLUME)


      I tried to make expression dynamic then it is not working(value=0 incorrect)

       

                                         1)    sum({<SCOPE={'YES'},NUMBER={"$(=max(NUMBER))"}>}total VOLUME)

                                                                                  

                                                                                      or


                                           2) sum({<SCOPE={'YES'},NUMBER={'$(=max(NUMBER))'}>}total VOLUME)


      Both the expressions are not working ,

       


      LOAD

       

        right("/BIC/A_CDAYS",3) as NUMBER

       

      FROM [lib.qvd]

      (qvd);

      Capture.PNG

      kindly suggest how to make it dynamic



      thanks