Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need a formula

Paridhi_Agrawal
8 - Asteroid

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

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora

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

AC1204968_Issue_1.png

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
8 - Asteroid

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

 

Christina_H
14 - Magnetar

This should workimage.png

Labels