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.
Employee | Total |
A | 18 |
B | 9 |
Total | 27 |
Solved! Go to Solution.
Hi @BosKev ,
Sort and use iif([Employee] = 'Total' , [Total] , [Row-1:Total]) in multi row formula .
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.
Employee | Total |
A | 0 |
B | 0 |
Total | 27 |
Thanks, I got it working.