Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Inter Formula with String Results

Fescobar
8 - Asteroid

Hello Community,

 

I hope that you're all doing well.

 

I am trying to create a formula that is looking at an integer and and based on the value should return either Available or Unavailable.

 

IF [sum] >0 then"Available" Else "Unavailable"
EndIf

 

The problem is that no matter what I try to change the Data Type on "sum", I am encountering an issue.  I've tried the ToString option, but it's not liking it either.  Attached are screenshots, sample data, and the workflow.  

 

Any assistance will be awesomely appreciated.

 

Available or Unvailable.jpg

2 REPLIES 2
binuacs
21 - Polaris

@Fescobar the sum field is double and you cannot assign a string value to double data type I added a new field and applied the formula

binuacs_0-1646862479939.png

 

Fescobar
8 - Asteroid

.@binuacs 

 

Awesomely simple solution...Create a new column with the appropriate value.  Thank you SO much!!

 

Fausto

Labels
Top Solution Authors