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

    Getting the first and last values of a selection


      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?