Free Trial

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
11 - Bolide

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
21 - Polaris

@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
11 - Bolide

That worked.. Thanks!!

Labels
Top Solution Authors