5 Replies Latest reply: Nov 30, 2016 5:20 AM by Joris Lansdaal RSS

    Syntax set analysis

    Joris Lansdaal

      Hi all,

       

      I have a syntax issue. In my app I've got the field Target_FY_Name: 2016, FY16, FY15-16.

      For Target_FY_Name = 2016:

      The working syntax is: Sum({<Target_FY_Name={"$(=Year(Today()-2))"}>} Target_FY)

       

      But I don't know how to write the syntax in combination with Text.

      For Target_FY_Name = FY16:

      Sum({<Target_FY_Name={"........$(=Right(Year(Today()-2),2)"}>} Target_FY)

      I've Tried 'FY'& but can't find the right syntax..

      Can anyone help me?