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

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

Start.JPG

End.JPG

SUM.yxzp

Developer

Behavior Analysis

Accepted answers

MilindG

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

SUM.yxmd

All comments

MilindG

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

SUM.yxmd

Bren_Spill2

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

Arno_M

Thank you! Worked out great.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335