Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎09-18-2023 08:05 AM

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

 

 

 

 

 

Input with Instructions.xlsx
Labels:
Reply

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
binu_acs
21 - Polaris
‎09-18-2023 08:14 AM

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

image.png

Reply
0 Likes
ArijitRoy
8 - Asteroid
‎09-18-2023 09:29 AM

Thanks @binu_acs. It worked. 😊

Reply
0 Likes
Labels
Top Solution Authors
View All