8 Replies Latest reply: Aug 31, 2015 7:32 AM by Massimo Grossi RSS

    Take the last value in set expression

      Dear Expert,

       

      last value.png

      Based in the picture above, I have 2 object.

      I want to create a text object where the result is the last value of field MANDAYS in table HEADCOUNT, based on the value of table CAL_YEAR that I choose.

      For example, in that picture above, the result that I want is 876,092


      What should I type in the expression to make that result?

       

      Thank you for your helping.