11 Replies Latest reply: Jul 31, 2017 7:54 AM by Sunny Talwar RSS

    how to display  selected yr 0 transactions

    naveen kumar

      Hello Everyone,

                              Can any one help me in  writing a expression for a requirement ,i need to show only those vendors and materials who is having nil transaction in selected year(Zero) and having transaction in selected previous year (expression need to be reflect  dynamically based up on selected year)

      For example

      vendor material  volume  year

      xxx        aaa          0          2017

      xxx        aaa        1234        2017

      xxx        aaa        -1234      2017

      yyy        bbb        100        2017

      xxx        aaa        1000      2016


      if a fiscal year 2017 is selected i need to display this in a table


      vendor    material          selected year volume(2017)            selected previous year volume(2016)

          xxx        aaa                          0  (0+1234-1234=0)                          1000


      vendor yyy has transaction in selected yr so this vendor should not display



      thanks

      naveen