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

[Karl_Spratt]

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?

[fmvizcaino · Accepted solution]

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.

Best,

Fernando Vizcaino