Status Descending and Ascending based on rows

Question

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

WeekEndingNameRate2021-01-22James32021-02-05James42021-01-22Peter32021-02-05Peter42021-01-22John12021-02-05John02021-01-22Mark

32021-02-05Mark2

Desired Output

WeekEndingNameRateStatus2021-01-22James3Ascending2021-02-05James4Ascending2021-01-22Peter3Ascending2021-02-05Peter4Ascending2021-01-22John1Descending2021-02-05John0Descending2021-01-22Mark

3Descending2021-02-05Mark2Descending

RolandSchubert · Accepted Answer

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