comparing 2 numbers

Question

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?

DateaccRateNew Rate4/30/2022123355 4/30/20225458353 4/30/2022848165 4/30/20225187858 4/30/20221854859 4/30/20225185522 4/30/202251854811 4/30/20225685455 4/30/2022545138 4/30/20221552611 4/30/20222151261 4/30/202256154253 4/30/2022515125 4/30/20221515146 4/30/2022215124 5/31/20225185522 5/31/202251854811 5/31/20225685456 5/31/2022545131 5/31/20221552612 5/31/20222151261 5/31/202256154253 5/31/2022515126 5/31/20221515145 5/31/2022215122

test2.xlsx

Robin_McIntosh · Answer

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.

Discussion_Comare_Rate.yxmd

IraWatt · Answer

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

Workflow.yxmd