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%))
Hi @Inactive User
It seems to work for me. Can show me whats the error you are getting.
Workflow:
Hope this helps : )
Formula would be
IF [useful life]!=39 and [project start date]>"2017-09-27" then "100%"
ElseIF [useful life]!=39 then "30%"
Else "0%"
Endif
not working. 😞
@Inactive User
@atcodedog05 again faster with the reply haha ;-)....
Hi @Sebastiaandb
It looks like MakeDate() is not an Alteryx function can you check 😅
😞
@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
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.
@Sebastiaandb
I didnt know that this function was present in jdunkerly's formula addons. Its definitely an addon. Thank you for sharing 🙂
atcodedog05
atcodedog05 you are the MAN. i changed the data type and it is working. THANK YOU SO MUCH.
Can you try by running it once.
Can you connect your input file to my attached workflow and try.
