6 Replies Latest reply: Feb 12, 2016 1:37 PM by Dave Melillo RSS

    Flag Based on Selected Period

    Dave Melillo

      My issues is that I have preferred suppliers that change from year to year. I want to be able to report on preferred supplier spend depending on the year selected by the end user.

       

      Right now my approach is to create an apply map based on the table below:

       

      Supplier201420152016
      Supplier1YNY

       

      My idea would be to create three different fields ... i.e Preferred 2014 Flag, Preferred 2015 Flag, Preferred 2016 .. but there are many issues that come with this approach and I am not sure it is going to work.

       

      Does anyone have another suggestion? The end goal would be for Supplier1's spend to be calculated under preferred for 2014 and 2016, but not 2015.

       

      Thank you,

       

      - dave