4 Replies Latest reply: Sep 22, 2017 8:57 AM by naveen kumar RSS

    Zero amount in selected FY and some amount in selected previous FY

    naveen kumar

      Hello All,

      I need a suggestion in achieving the below requirement,what i need to show is ,for selected fiscal Year show only

      those vendors who spend is ZERO and has some spend in selected previous year. what i mean is from the below sample table


      Fiscal Year      Vendor      Amount

      2016               AAA         100

      2016               AAA         200

      2016               BBB         300

      2016               CCC         50

      2017               AAA        -50

      2017               AAA         50

      2017               BBB         100

      2017               BBB         -100

      2017               CCC          1000

       

      If i select Fiscal Year :2017


      Output:Select

      Vendor      Selected year Amount(2017)          Previous Year Amount(2016)

      AAA                  0(50-50)                              300(100+200)

      BBB                  0(100-100)                             300

       

      Only those two vendors need to display because CCC has some spend in 2017 and has spend in 2016.....



      Thanks