7 Replies Latest reply on Nov 16, 2016 7:03 AM by Sabine Honer

    Create Case statement, return year and use it as filter

    Sabine Honer

      Hi All,


      I have following issue:


      I have a calculated field like


      Case [Field]

      WHen "A" Then 2010

      When "B" Then 2011

      When "C" then 2012



      I have also a year field

      I would like to use my calculated field as input or filter criteria for my year field.


      Any hints how it can be achieved?

      I had no luck so far...



      Best regards