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

Multiplying lists of numbers together

Meteor

I have a list of random numbers that I want to multiply together. Similar to the Summarize sum function, but instead of a+b+c+d, I want a*b*c*d.

 

Is there a good way to do this?

Assuming your list is in rows, I would use the multi-row formula tool. I've attached a quick example.

 

I've run into this same issue before, so you may want to star my idea to have product added to the summarize tool: https://community.alteryx.com/t5/Alteryx-Product-Ideas/Add-Product-to-Summarize-tool/idi-p/26682

 

Hope that helps.

Meteor

Thanks for the solution! I starred your idea as well.

Labels