Need a formula

[Paridhi_Agrawal]

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

[Yoshiro_Fujimori]

Hi @Paridhi_Agrawal ,

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

[Paridhi_Agrawal]

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

[Christina_H · Accepted solution]

This should work