community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Multi-row replace with condition

Highlighted
Asteroid


Hello All,

 

I want to replace the rows above in a table with the total , what would be the formula for this in a multi row tool? Thanks.

 

example below, I want to replace Employee A, B's "Total"with the number 27.

 

EmployeeTotal
A18
B9
Total27
Quasar

Hi @BosKev ,

Sort and use iif([Employee] = 'Total' , [Total] , [Row-1:Total])  in multi row formula .

Asteroid

Hi @benakesh ,

 

Can you explain the use of sort ? also I didn't have additional rows you created. I got the following...I skipped the sort function because the total will always be larger than the rows above. Thanks.

 

 

EmployeeTotal
A0
B0
Total27
Asteroid

Thanks, I got it working.

Labels