Last day of the found set
I'm trying to extract the last day of the found set but for that month.
Say the month has not ended, I want a daily average. The way it's set up right now, I took the last day of each month as a number field and divided the month's revenue by that number to get the daily average. This works if the month is over, however if I don't have the records because the month is not yet over, then I need to divide either by the current day, but that would not allow it to be the same calculation value for months that are over. So I'm trying to extract the last day of each month of the found set. How do I do that?
FOUND SET: 10/1/10, 10/2/10, 10/2/10, 10/6/10 ------> extract 6