List Box & Formula tool

[danielmaguire]

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]

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 : )