Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multi-row replace with condition

BosKev
8 - 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
3 REPLIES 3
benakesh
12 - Quasar

Hi @BosKev ,

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

BosKev
8 - 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
BosKev
8 - Asteroid

Thanks, I got it working.

Labels