Status Descending and Ascending based on rows

[Ultralightbeam]

Hello guys, I want to determine if the recent week's rate is bigger than the previous week  basedd from multiple columns

WeekEnding	Name	Rate
2021-01-22	James	3
2021-02-05	James	4
2021-01-22	Peter	3
2021-02-05	Peter	4
2021-01-22	John	1
2021-02-05	John	0
2021-01-22	Mark	3
2021-02-05	Mark	2

Desired Output

WeekEnding	Name	Rate	Status
2021-01-22	James	3	Ascending
2021-02-05	James	4	Ascending
2021-01-22	Peter	3	Ascending
2021-02-05	Peter	4	Ascending
2021-01-22	John	1	Descending
2021-02-05	John	0	Descending
2021-01-22	Mark	3	Descending
2021-02-05	Mark	2	Descending

[RolandSchubert · Accepted solution]

Hi @Ultralightbeam ,

you could use a Multi-Row Formula to compare week and previous week and set status accordingly. The result could be joined to your data.

I've attached a sample workflow. This works for 2 weeks in data only, if your input data contains more than 2 weeks, a Filter would be needed.

Let me know if it works for you.

Best

Roland 

[messi007]

@Ultralightbeam,

Please see bleow:

Attached the workflow,

Hope this helps!

Regards