3 Replies Latest reply: Nov 12, 2010 6:45 AM by mauich123 RSS

    Getting the first and last values of a selection

    mauich123

      Hi. I have a date field and an inventory field in my file and I would like to add the last and first inventory of the selected date range and divide it by 2 to get the average inventory. I've tried to do this with sets but with no luck at all. Any ideas?

      Thanks