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

    Expressions in text boxes

    Cristina Fiacconi

      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:

      =count(if(inyear(Termination_Date,vMaxDate,-1,7),HRP_Code))

       

       

       

      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.