I have a report that displays warranty item count totals based on month. The totals change daily as new items are added (open) and existing items are completed (closed). I would like to capture those values at the end of each month, so that I can see a trend. Example:
As of 11:59 PM, January 31st, 2014. the total open warranty items was 58.
As of 11:59 PM, February 28th, 2014. the total open warranty items was 52.
As of 11:59 PM, March 31st, 2014. the total open warranty items was 46.
As of 11:59 PM, April 30th, 2014. the total open warranty items was 38.
etc.
The formula must capture the count of open items and then save that number as a value that I can reference as a static number.
Thanks in advance for any suggestions.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.