Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

muti row formula question

ryanzhang487
8 - Asteroid
‎02-07-2023 09:59 AM

Hi community,

I would like to create a column in alteryx (highlight in yellow) saying that when [stardard time hrs] column is 0 then the row above will be the last step else null

Thank you for your help

Screenshot 2023-02-07 124819.png

standard - Copy.xlsx
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
ShankerV
17 - Castor
‎02-07-2023 10:05 AM

Hi @ryanzhang487 

 

Please find the expected output.

 

ShankerV_0-1675793085695.png

 

 

Multirow 07022023.yxmd
Reply
binu_acs
21 - Polaris
‎02-07-2023 10:05 AM

@ryanzhang487 One way of doing this by grouping the Work Type in the Multi-Row tool

 

binuacs_0-1675793101380.png

 

Multi-Row_070223.yxmd
Reply
Labels
Top Solution Authors
View All