We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

How to error check for only numbers from user input in an analytic app

csh8428
10 - Fireball

I have an analytic app. One of the user entered values can only be a positive number(can be a decimal). I know how to error check for blank values, but not how to check for data types.

 

What expression would I enter into the error tool to check for that?

screenshot.png

 

 

Thanks for any help!

 

Craig

3 REPLIES 3
Prometheus
12 - Quasar

@csh8428 I would suggest using a Numeric Up Down tool instead of a Text Box tool if you want your users to only input numbers. The configuration allows you to set up/down increments, min, max, and decimal places.

binuacs
20 - Arcturus

@csh8428 You can use the Regex function to check whether the incoming data is numeric or not

REGEX_CountMatches([#1],'[^\d\.]')>= 1

image.png

csh8428
10 - Fireball

That worked.. Thanks!!

Labels