How do you sum multiple columns w/ string & number values into a total

[Arno_M]

Hello,

How do you build a column that can sum only the numbers for an overall total, and if there are no numbers, simply list the first value in PD1 as the total? I have three columns that can include both numbers and strings.

Thank you

[MilindG · Accepted solution]

@Arno_M I'm sure they are better ways to achieve this but see if this works for you.

[Bren_Spill]

Solved: Re: Numeric and string data in one field - Alteryx Community

[Arno_M]

Thank you! Worked out great.