Excel formula

[Abhishekjoshua]

Can someone help me achieve this formula in Alteryx? Thanks in advance

[ShankerV · Accepted solution]

Hi @Abhishekjoshua 

Please find the expected output for your question.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[Qiu · Accepted solution]

@Abhishekjoshua 
Maybe something like this.

[Abhishekjoshua]

Thank you so much @ShankerV  and @Qiu  for quick replies. Appreciate it!

[Abhishekjoshua]

Hello @ShankerV , I have tried with your formula but unable to end it. Please have a look at my formula in the end and provide your inputs. Thank you.

[ShankerV]

Hi @Abhishekjoshua 

I see there is a red line (prompting an error) under the <91 formula.

Hence you are not able to end it and the output is not reflected  after you run the workflow.

Can you please paste few sample inputs, not full, just to analyze the error.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Abhishekjoshua 

Please check whether your column which you use is String type, it should be Int type for the formula to make it work.

Column to be checked is [Ticket age when escalated]

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Abhishekjoshua 

See as I expected, it is the same issue.

Datetype error, it is String type you are using.

I modified to Sting using select, the same error pops-up.

Use the select tool and change the Datatype to Int.

Many thanks

Shanker V

[Abhishekjoshua]

Thank you so much again! you are awesome. Thank you