Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiply Values in Same Column Based on Conditional

samgregory5
5 - Atom

I'm trying to create a product of all value in a column that share the same value in a different column. 

 

As an example, in the picture below I am trying to create column C based on the values in columns A & B. All rows in column B that have the same value in column A, should be multiplied together to get the value in C.

 

 

samgregory5_1-1660610527011.png

 

 

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@samgregory5 
I think we can do it by a Dynamic replace, but still working on it. 😁
Hope someone can enlighten us.

sparksun
11 - Bolide

One way to get it done

sparksun_0-1660623329259.png

 

samgregory5
5 - Atom

Thank you!!!!

Labels