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
Solved! Go to Solution.
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
@Yoshiro_Fujimori , The sequence of data is not same all time, so we cant use row-1/ row+2 in formula.