6 Replies Latest reply: Sep 24, 2014 10:03 AM by Cristina Fiacconi RSS

    Expressions in text boxes

      Hello Community,

      I have a few text boxes on my module to show a few summary figures, such as Last Year Terminations, Last year New Starters, etc.


      Can I use Set Analysis in text boxes or are there limitations? Because I don't seem to be able to get a summary to work when considering terminations from year before the selected one.

      I tried:





      but it does not work. This same expression will work when instead of Termination_Date I query Start_Date, but that's because start date is associated to my master date. That's why I thought Set Analysis would work, but I can't get the syntax right.