Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How I can I write this formula in alteryx or any alternatives

MahmoudEssawy
5 - Atom

Hi All,

 

I have this formula that I did on Excel and I was wondering how I can write it in alteryx as I know there is no ( - ) between If 

=IF(I7<$S$2,0,((((IF(E7>$S$2,E7,$S$2)-IF($S$3>I7,I7,$S$3)))/365)*U7*J7))

You will find the formula and what I mean in attached photo below

2 REPLIES 2
mbarone
16 - Nebula
16 - Nebula

In Alteryx, that format is a boolean conditional (as opposed to if/then/else).  For that, you'll want to use the double "i" if, meaning "IIF"  That should fix it up.

 

Here's a link to the help files on conditionals in Alteryx:  https://help.alteryx.com/20212/designer/conditional-functions.

 

thiago_belarmino
8 - Asteroid

Try it.

 

IF [COLUMNAME I7] < [COLUMNAME $S$2] THEN 0
ELSE
(((IF [COLUMNAME E7] > [COLUMNAME $S$2] THEN [COLUMNAME E7]
ELSE [COLUMNAME $S$2]
ENDIF)
-
(IF [COLUMNAME $S$3] > [COLUMNAME I7] THEN [COLUMNAME I7]
ELSE [COLUMNAME $S$3]
ENDIF)
/365)* [COLUMNAME U7] * [COLUMNAME J7])
ENDIF

Labels
Top Solution Authors