emerywang Posted January 31, 2004 Share Posted January 31, 2004 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 Link to comment Share on other sites More sharing options...
John Caballero Posted January 31, 2004 Share Posted January 31, 2004 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? Link to comment Share on other sites More sharing options...
emerywang Posted January 31, 2004 Author Share Posted January 31, 2004 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7384 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now