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.

Arno_M
6 - Meteoroid

Thank you! Worked out great.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels