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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Multi-row replace with condition

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
Highlighted
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