Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

If Else statement problem

wave_wstn
7 - Meteor

Hi Alteryx, 

I am trying to put this formula in, and I have seen this formula work on another workbook for the same data, but I am not sure why it is not running. Can someone help pls?

 

Thanks!

 

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @wave_wstn,

 

The daily change is a string format. You need to change:

 

then "0"

 

You need to put 0 in "" if it isn't a number format. 

BenMoss
ACE Emeritus
ACE Emeritus

You are working with a CSV input which will bring in all your fields as strings, but you are trying to subtract one value from another, a numeric operation.

 

Bring a select tool onto your canvas to change the data types to numeric.

 

Ben

Qiu
20 - Arcturus
20 - Arcturus

@wave_wstn 
Just an illustration based on others advide.

We should always be aware the data type we are dealing with.

And one more point, I think you may want your "Daily Change" field to be numeric as well.

0414-wwhiston.PNG0414-wwhiston-1.PNG

Labels