Column calculation

I am now trying to do a division between both of those series of columns, dynamically. See below screenshot, I am doing current field / by the Right current field name (1) which refers to the first columns, but I can't make it refer to those previous fields.

In the below case, I would need to do -1080 / 1080.12 for France.

Thanks!

Andreas

Andreas92

Hi @PhilipMannering,

I am now trying to divide between both sets of columns. I now need to dynamically divide column 2-1 by column 1. See below screenshot. I tried with doing a Right current field name it doesn't work, it's not taking the right side of the division as a field ( [1] ) but rather as a number to be applied for the division.

How can I work around this?

Thanks,

Andreas

philipmannering

Like with the difference, I think you would want to calculate the % difference on the pivoted data using a Multi-Row Tool. See attached,

column calculation.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703