Alteryx Designer Desktop Discussions

danielmaguire · ‎09-25-2020

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

atcodedog05 · ‎09-25-2020

Hi @danielmaguire

Can you provide your workflow

mbarone · ‎09-25-2020

If you could upload a mock module, that would help. You'll probably want to use the option in the list box to "Generate Custom List" with the brackets and + sign.

danielmaguire · ‎09-25-2020

Essentially, whatever the user selects from the list box, i want the find and replace to append fields to record that selection and then i want to sum that selection in the formula tool and insert it into a new column called 'Total'.

atcodedog05 · ‎09-25-2020

Hi @danielmaguire ,

Here is the modified workflow to do it.

You need action on select tool to pick only specific columns

Hope this helps : )

If this helps please mark the post as solution.

danielmaguire · ‎09-25-2020

Hi, thanks for providing the workflow. I am still getting an error on the Find & Replace tool. Let's say if my input only includes a,b,c. I am getting the error that 'd' is not contained in the record. I believe that this is because d,e,f etc. is included in the 'append fields to include' but it is not in my input. Any advice would be greatly appreciated.