Alteryx Designer Desktop Discussions

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

Multiplying lists of numbers together

dakeefe
7 - 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?

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor

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.

dakeefe
7 - Meteor

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

Labels