Comparing values in different records

[emerywang]

Hi. How do I compare a value in my current record, to its value (in the same field) in a previous record? For example, I want to compare the current price of an item to its price 12 records ago.

Thanks.

-Emery

[John Caballero]

You could set your previous value in a global and then compare it to the current value. How are you determining how far back to go to compare?

[emerywang]

Thanks, John. I need to do YTD comparisons. I need to compare the current price with its price at the beginning of the year. So in June, I need to go back 6 records, in August, 8 records, and so on. Then when the next year rolls around, it needs to start over, and compare to the first month of that new year.

-Emery