In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

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

Arno_M
6 - Meteoroid

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

3 REPLIES 3
MilindG
12 - Quasar

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

Bren_Spill
12 - Quasar
12 - Quasar
Arno_M
6 - Meteoroid

Thank you! Worked out great.

Labels
Top Solution Authors