Formula not Working

[Inactive User]

Can someone please suggest me how can I use this formula on Alteryx?

IF(AND([useful life]<>39,[project start date]>DATE(2017,9,27)),100%,IF([useful life]<>39,30%,0%))

[Sebastiaandb]

@atcodedog05 you're right haha... Can't really see if it's an add-on in Designer itself. They installed in into our virtual applications :-). 

Function List · jdunkerley/AlteryxFormulaAddOns Wiki · GitHub

[atcodedog05]

Hi @Inactive User 

I am really surprised the same condition is working but not below 😶. Can you use a select tool before and change the datatype of [useful life] to double.

[atcodedog05]

@Sebastiaandb 

I didnt know that this function was present in jdunkerly's formula addons. Its definitely an addon. Thank you for sharing 🙂

[Inactive User]

not sure why it not working for me. @atcodedog05

[Inactive User]

@atcodedog05 you are the MAN. i changed the data type and it is working. THANK YOU SO MUCH.

[atcodedog05]

Hi @Inactive User 

Can you try by running it once.

Can you connect your input file to my attached workflow and try. 

[atcodedog05]

Happy to help : ) @Inactive User 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!