Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How do I do a Countif on a Range of values in Alteryx

Karl_Spratt
8 - Asteroid

Hi, New to Alteryx so please forgive these learner questions, I'm sure I will have lots.

 

I have a manual report I would like create a automated WF, but one of the things is how do I do  this  in Alteryx?

Current excel is: =COUNTIF(AF2:CE2~"<1") Also Alteryx is importing my values in cols AF2: CE2 as Field Type V_WString.

Does this need to be changed?

 

Countif.PNG

 

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hi @Karl_Spratt ,

 

If you want those values to be used as numbers somehow, you will need to change the data type to double or integer.

Example attached.

fmvizcaino_0-1592399268941.png

 

Best,

Fernando Vizcaino

 

Labels
Top Solution Authors