AnsweredAssumed Answered

Last day of the found set

Question asked by BeachedWhale on Feb 25, 2013
Latest reply on Feb 26, 2013 by jmw

Title

Last day of the found set

Post

     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?

     Example:

     FOUND SET: 10/1/10, 10/2/10, 10/2/10, 10/6/10 ------> extract 6

     Thanks!

Outcomes