Duplicate the Excel formula in Alteryx

[SwatzJaswal]

Hello Alteryx,

I have a requirement in which I need to replicate the excel formula in alteryx . Any help would be appreciated.

Thanks.

[grazitti_sapna]

Hey @SwatzJaswal , can you please give us an idea about the excel formula you are using.

[SwatzJaswal]

@grazitti_sapna , thanks for reminding here is the sample excel.

[grazitti_sapna · Accepted solution]

@SwatzJaswal , Here is how you can achieve your results in alteryx.

[ShankerV · Accepted solution]

 @SwatzJaswal 

One way of doing this.