Need a formula

Hi team,

In attached excel file,

In Solution tab- I have a formula at Outward metrics values that calculates data by taking values at Net_Adds and Inward metrics.

I need to do the same in Alteryx.

The data is in Sheet1 without any formula

can anyone help?

thanks

Paridhi

Accepted answers

This should work

Here is one way of doing this.

There may be more scalable solution, but if you have only two columns, this would work.

Workflow

Formula for Value1

IF [Metrics] = "OUTWARD" THEN [Row-1:Value1] - [Row-2:Value1] ELSE [Value1] ENDIF

Formula for Value2

IF [Metrics] = "OUTWARD" THEN [Row-1:Value2] - [Row-2:Value2] ELSE [Value2] ENDIF

@Yoshiro_Fujimori , The sequence of data is not same all time, so we cant use row-1/ row+2 in formula.

This should work