We have an RW100 report where my business user wants some changes listed below. I asked Infor Support, but they said that they don't have the kinds of built in functions that I'm looking for. Has anyone attempted to do anything like this?
Thank you.
Kelli
1. My user wants a column for last quarter total amount. As the heading, they want to display the number of the quarter. Is ther an
@LQ data dictionary item for last quarter? For instance, when we are in quarter 1, they want the column heading to say 4 since that was the last quarter number. I only saw
@CQ in the users guide for current quarter.
2. They want the column to contain the last quarter's total amount. It shouldn't be a rolling amount.
So, for the months of January, Feb, March 2014, they want the column to remain last quarter's total amount (that would be the sum of Oct - Dec 2013). In January, they want to see this total, along with in February and March. So, I can't do the sum of 3 prior periods, because it actually changes. In Jan, it would be the sum of 3 prior periods, but in Feb, it would be the sum of the 2nd - 4th prior periods. (they don't want January since that's the current quarter). In March, it would be the sum of the 3rd - 5th prior periods, since they don't want the totals for Jan and Feb since that's in the current quarter.
