[Help] Convert Excecl formula into Alteryx Friendly Code

[Arcane]

Hi Folks,

Can someone help me convert this into Alteryx friendly code? Tried two versions of my conversion into Alteryx friendly. But, looks like I am messing up some loop.

=if(
and(
Sheet1[sheetname]="yt_a",
Sheet1[PYValue]<Sheet1[YValue]
),
if(
Sheet1[level]="7Z",
Sheet1[YValue],
if(
and(
value(Sheet1[level])>=42,
value(Sheet1[level])<=84),
Sheet1[YValue],
if(
and(
Sheet1[S_Validation]="Yes",
or(
value(Sheet1[level])=50,
and(
value(Sheet1[level])>=14,
value(Sheet1[level])<=18
)
)
),
Sheet1[PYValue],
if(
Sheet1[RecFlag]="Yes",
Sheet1[YValue]-1,
Sheet1[PYValue]
)
)
)
),
Sheet1[PYValue]
)

Thanks in advance. :)

[atcodedog05]

Hi @Arcane 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[Arcane]

Not sure if I can get a sample.

[danilang]

Hi @Arcane 

Can you at least post your two attempts and we'll see if we can figure out where you went wrong.

Also: are you getting field conversion errors or is the output not correct?

Dan