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

[MahmoudEssawy]

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

[mbarone]

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]

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