Hello,
I'm trying to compare accounts by date and see if there was any rate change. What is a good way to do that? I need the report to open a new column that will show the new rate for the latest month (May). Basically compare 4/30 to 5/31 by the acc and then if the rate is different on 5/31 then put the new rate in column New Rate. How can i do this?
Date | acc | Rate | New Rate |
4/30/2022 | 12335 | 5 | |
4/30/2022 | 545835 | 3 | |
4/30/2022 | 84816 | 5 | |
4/30/2022 | 518785 | 8 | |
4/30/2022 | 185485 | 9 | |
4/30/2022 | 518552 | 2 | |
4/30/2022 | 5185481 | 1 | |
4/30/2022 | 568545 | 5 | |
4/30/2022 | 54513 | 8 | |
4/30/2022 | 155261 | 1 | |
4/30/2022 | 215126 | 1 | |
4/30/2022 | 5615425 | 3 | |
4/30/2022 | 51512 | 5 | |
4/30/2022 | 151514 | 6 | |
4/30/2022 | 21512 | 4 | |
5/31/2022 | 518552 | 2 | |
5/31/2022 | 5185481 | 1 | |
5/31/2022 | 568545 | 6 | |
5/31/2022 | 54513 | 1 | |
5/31/2022 | 155261 | 2 | |
5/31/2022 | 215126 | 1 | |
5/31/2022 | 5615425 | 3 | |
5/31/2022 | 51512 | 6 | |
5/31/2022 | 151514 | 5 | |
5/31/2022 | 21512 | 2 |
Hey @ntudev,
Here is one way to do this using the multi row formula tool:
If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872
Any questions or issues please ask :)
HTH!
Ira