Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need help with the formula

ArijitRoy
8 - Asteroid

Hello Friends,

 

I have attached a input file which includes the instructions about what I required. Only use column A and B as input. Under D column is the output I require and instructions under E column.

 

Billow pictures of the Formula I have tried but getting error. Tried with ToNumber also. Please help

 

2nd Formul tried.png2nd Formul Error.png1st Formul Tried.png

 

 

 

 

 

2 REPLIES 2
binuacs
21 - Polaris

@ArijitRoy You need to re-write your formula like below

image.png

ArijitRoy
8 - Asteroid

Thanks @binuacs. It worked. 😊

Labels
Top Solution Authors