Alteryx Designer Desktop Discussions

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

Subtraction Calculation Error

RCern
8 - Asteroid

I am trying to do a simple subtraction calculation and I am getting an error.  Half of the equation works, but when I attempt to subtract a third component, I get an error that I can't figure out what I am doing wrong.  Can anyone advise?

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

You are storing those columns as VWStrings (aka text) - change them to numeric and it should work!

RCern
8 - Asteroid

Well that is embarrassing.  Thank you.  Been looking at it so long I didn't even realize. lol

alexnajm
18 - Pollux
18 - Pollux

Happens to the best of us! ðŸ˜Š

Labels
Top Solution Authors