Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Invalid type in operator

GQuirino
5 - Atom

I'm using a NumericUpDown in a filter. But it is not working. I've already checked the data format and it's as double.

 

Does anyone know why it's not working?

 

GQuirino_0-1652730433353.pngGQuirino_1-1652730460134.png

 

5 REPLIES 5
DataNath
17 - Castor
17 - Castor

I believe you need to wrap [#1] in ToNumber().

 

DataNath_0-1652731067797.png

 

 

IraWatt
17 - Castor
17 - Castor

hey @GQuirino,

What is the type of [#1]? It must not be a number type

GQuirino
5 - Atom

I put the ToNumber() but the filter didn't work, it's not delivering any value as true and it should

 

GQuirino_0-1652731266013.pngGQuirino_1-1652731318599.png

 

GQuirino
5 - Atom

I believe it is number, no?

 

GQuirino_0-1652731567573.png

 

DataNath
17 - Castor
17 - Castor

At the moment, you're just running the workflow and there's no number populated so nothing is satisfying your filter. If you actually try and run it via the debug (in the interface designer - Ctrl+Alt+D), or just run as an app using the magic wand icon, you'll be able to see it.working:

 

DataNath_0-1652732088805.pngDataNath_1-1652732098425.pngDataNath_2-1652732107255.png

 

Labels