comparing 2 numbers

[ntudev]

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

[IraWatt]

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

[Robin_McIntosh]

Multi-row formula.  But you don't mention what you want if the rates match.  In this example, I set the new rate to zero if they match.