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

      Sabine