Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Multi-Field and Multi-Row Formula Tool Versatility

I like how the Multi-Row and Multi-Field tools have a variable tab to help the user know the proper syntax for building their formulas such as Row-1, Row+0, and Row+1.  That said, it would be nice if the user could change the Expression manually to point to different rows.  You don't necessarily need all of these variables listed, but if the user could change to [Row-2:Fieldname] so that the formula could look two or more rows up/down.  I have a report where I want to divide one row up by the value two rows up.  I have to use a workaround where this would make it much easier.

 

Additionally, it would be nice if the Multi-Field tool could accept Multi-Row functions mixed with the Current Field function... such as [Row-1:_CurrentField_]

 

I understand these are two requests, but the ask is similar...simply that the syntax is understood in both and more versatile.