Alteryx Designer Desktop Discussions

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

Product function for all rows below a specific row

feedsoal
6 - Meteoroid

I'm trying to replicate the "PRODUCT" function in Alteryx for a specific case. I've done it before in an easier case, but I don't even know how to start in this case.

 

I have to multiply values in Column C to get the results in Column D, as in the example xlsx file.

 

feedsoal_0-1671077325579.png

 

How can I replicate it to Alteryx? I spent a day trying to do it and I truly have no idea how to start.

 

 

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @feedsoal 

 

One way of doing this, using the multi row formula.

 

Felipe_Ribeir0_0-1671078477353.png

 

PanPP
Alteryx Alumni (Retired)

Hi @Felipe_Ribeir0 

 

I think you uploaded the wrong workflow !

Felipe_Ribeir0
16 - Nebula

@PanPP Thanks for letting me know!

 

Uploaded the correct one now!

feedsoal
6 - Meteoroid

Thank you, Felipe! It worked just fine and is saving a lot of time and space in my workflow!!!

Labels