Issues with multi row formula

Question

Hi guys,

Looking for a bit of help with the multi-row formula.

I have attached the current vs desired state, but can't seem to make it work, I haven't had the chance to work much with alteryx.

Can someone help?

Thanks a lot,

Filip

current vs desired state.png

IraWatt · Accepted Answer

Hey @FilipViterra,

I have attached an example of how to do this:

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

Ira Watt
Technical Consultant
Watt@Bulien.com

JamesCharnley · Accepted Answer

Hi @FilipViterra, Here's how I would match your desired output. One multi-row is to update the New Status column until the year is not active, and the next will add one to the first active until the same point

binu_acs · Accepted Answer

@FilipViterra One way of doing this

binu_acs · Accepted Answer

@FilipViterra You need the select the CLIENT_NR field in the Group By column of the Myulti-Row formulas