community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Summing over indices

Atom

Hello, 

 

I am trying to do a sum over indices and am unsure how to go about it. I've tried the Multi-Row formula, but it is pretty cumbersome and has been returning a 0 value. I would like to perform something along the lines of the following:

Equation.png

Where 'n' corresponds to the row number, and 'i' is the current (active) row. My data looks like this:

nPgamma
10.05.05
20.10.05
30.10.05
40.15.1
50.20.15
60.25.2
70.10.2
80.05.2

 

Thanks for your help!

Alteryx Partner

Well if someone can figure this one out using Alteryx tools, I have a star ready and waiting for them!

 

Personally, I'd try  busting out some "R" code and use the R tool on the Developer tab to get this done.

 

Assuming I have understood it correctly:

2017-06-08_20-37-10.jpg

 

Should do what you want.

Use and Append fields to create a Cartesian product (i.e. have all 8 rows for every row)

Compute the expression (post a little rearrangement)

Sum the values grouped for each i

2017-06-08_20-39-10.jpg

 

Labels