Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

List Box & Formula tool

danielmaguire
8 - Asteroid

Hi,

 

I am having trouble with combining the list box tool with the formula tool. Say for example I have 8 fields in the list box option (a,b,c,d,e,f,g,h). How can I get the formula tool to create a new column titled 'Total' which sums my selected fields. For example if I select a,b,c it should calculate: [a]+[b]+[c] in the new field? Or if I select d,e,f,g it should calculate [d]+[e]+[f]+[g] in the new field?

 

Any help is greatly appreciated.

 

Kind regards,

Daniel

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Hmm interesting approach.

 

Never knew or tried this. 

 

Your solutions are always amazing @danilang and provides an amazing opportunity to learn.

Thanks for this knowledge and exposure @danilang 

 

Looking forward to learning more : )

 

Labels