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

Using Alteryx mutilrow formula

Highlighted
Asteroid

Hi,

I appreciate some help in creating cumulative return column using multi-row formula. I added the Excel formual which I use to generate the value in the third column

 

thank you

 

AB 
-0.080059100 
-0.09911399.90089=B2*(1+A3/100)
-0.32713199.57408=B3*(1+A4/100)
-0.19085499.38404=B4*(1+A5/100)
Quasar
Quasar

How about:

 

[Row-1:B]*(1+[A]/100)

 

You can change the option for "Values for Rows that don't Exist" to NULL if you would like a Null value instead of a zero value when there is no prior record.

 

multi row.png

Labels