Column calculation

[Andreas92]

Hi,

I've been trying to do the following in Alteryx, I've tried working with multi row and multi field formulas but couldn't get anything going.

I'm trying to do a simple subtraction between column 2 and 1, and then continuing, 3 minus 2, etc. all this grouped by ID and Country.

Is there no current field minus previous field?

Thanks!

Andreas

[PhilipMannering · Accepted solution]

HI @Andreas92,

It takes a bit of wrangling, but something like this should help. See attached.

[Andreas92]

Thanks Philip!

I just had to change your join to join by ID and Country and not by position.

[Andreas92]

Hi @PhilipMannering,

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,