Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
communauté Alteryx IO MyAlteryx
alteryx Community
Search
annuler
Activer les suggestions
La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
Affichage des résultats de 
Rechercher plutôt 
Vouliez-vous dire : 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

COUNTIF less than a number

bwat2435
Météore
‎04-01-2020 03:03 AM

Hi All,

 

I have a dataset and I'd like to make a column which would have the equivalent excel formula =COUNTIF(A2:f2, "<30")

 

I've fiddled for a while and can't figure it out. Does anyone have any ideas? 

 

I have attached the spreadsheet if that helps.

 

Thanks in advance!

 

 

Aperçu du fichier
2 KB
Étiquettes :
Répondre
0 Compliments
2 RÉPONSES 2
OllieClarke
16 - Nebula
16 - Nebula
‎04-01-2020 03:35 AM

Hi @bwat2435 here's a way of doing it:

OllieClarke_0-1585737300508.png

 

countif.yxmd
Répondre
0 Compliments
bwat2435
Météore
‎04-01-2020 02:49 PM

Thank you Ollie! worked a treat 🙂

Répondre
GenAI Contest Form
License admin COmmunity Live
Étiquettes
Auteurs des meilleures solutions
Tout afficher