Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎06-17-2020 06:01 AM

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

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor
‎06-17-2020 06:08 AM

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

 

2020-06-17 How do I do a Countif on a Range of values in Alteryx.yxmd
Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels