Divide by a Row value and Multiply by a constant

[kanishka271]

I have the above table and I want to divide each column by the respective last row value and multiply each cell by 100 (except the last row, basically need the percentage)

Any help would be appreciated

[lelloba]

Hello @kanishka271 ,

here is a small workflow that should do what you asked.

Divide by row value – lelloba

Next time, please remember to attach a small dataset. It’s much easier to help and make things work faster

Have a nice day,
Raffaello

[Daniel_Weikert]

Your last value is always the biggest one (as the sum) I guess so you could use math formula multi column
current col / col_max (current_col) *100
br

[aworker]

Hi @kanishka271

Following @Daniel_Weikert’s trick, you will find below a solution that takes into account your other requirements too:

@kanishka271

I want to divide each column by the respective last row value and multiply each cell by 100 (except the last row, basically need the percentage)

The extra added trick here is to use a “if-then-else” condition to avoid dividing the last row too:

if($$ROWINDEX$$  + 1 < $$ROWCOUNT$$,
     100 * $$CURRENT_COLUMN$$ / COL_MAX($$CURRENT_COLUMN$$),
     $$CURRENT_COLUMN$$)

20221111 Pikairos Divide by a Row value and Multiply by a constant – pikairos

Hope it helps.

Best
Ael

[kanishka271]

Thank you. this is perfect!

Will surely attach a small dataset next time

[kanishka271]

This answers my query as well

[kanishka271]

Thank you! this answers the question as well