We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need to get the sum of a particular column by using Product formulae like in excel

Sameer_Kanade8810
7 - Meteor

Hi ALL,

 I have below data set where i need to apply a formulae like this excel =Product(1+A2:A4)-1

 

Which should give me a result 0.0150751249

 

Value 1
0.005
0.005
0.005

 

Is that possible please help

2 REPLIES 2
Clifford_Coon
11 - Bolide

Hi @Sameer_Kanade8810 ,

 

Something like this using multi-Row Formula

IF [Row-1:Result] = 0
THEN [Value 1]
ELSE (1 + [Value 1]) * (1+[Row-1:Result]) -1
ENDIF

Product.jpg

2 versions, 1 hard coded, on with parameters

acarter881
12 - Quasar

Hello, @Sameer_Kanade8810.

 

You may use an iterative macro for this, although the multi-row formula may be easier.

 

The get data in shape workflow transforms the data for input into the iterative macro.

 

I attached the iterative macro and the workflow to run the iterative macro.

 

You can subtract any value you want from the result.

 

Iterative Macro:

 

acarter881_0-1687304570340.png

 

Output:

acarter881_1-1687304618586.png

Labels
Top Solution Authors