Divide by a Row value and Multiply by a constant

[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