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

Nested IF function with additional subtraction

CFuser87
7 - Meteor

Hi,

 

I found a lot of formulas stating how an if function would work if it's under a certain threshold,

 

Just wondering how I would translate the following formula from Excel into Alteryx using the formula tool.

 

Would it be possible to keep it in one formula even with the subtraction since I need it for multiple columns?

 

=IF
End NBV (PY) - If (End NBV (PY) >0, Amort (PY), 0 ) >0,
End NBV (PY) - If (End NBV (PY) >0, Amort (PY), 0 )
0)

 

Thanks

2 REPLIES 2
Raj
16 - Nebula

@CFuser87 please find the formula attached.

IF [End NBV (PY)] - IIF([End NBV (PY)] > 0, [Amort (PY)], 0) > 0 THEN [End NBV (PY)] - IIF([End NBV (PY)] > 0, [Amort (PY)], 0) ELSE 0 ENDIF

mark done if solved.

CFuser87
7 - Meteor

Amazing! Thanks for the quick reply!

Labels
Top Solution Authors