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%))

[atcodedog05]

Hi @Inactive User 

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

Hope this helps : )

[Inactive User]

not working. 😞

[atcodedog05]

@Inactive User 

Sorry was missing a quote fixed it😅

IF [useful life]!=39 and [project start date]>"2017-09-27" then "100%"

ElseIF [useful life]!=39 then "30%"

Else "0%"

Endif

[Sebastiaandb]

@Inactive User 

[Sebastiaandb]

@atcodedog05 again faster with the reply haha ;-)....

[Inactive User]

Last formula is not working 😞

[atcodedog05 · Accepted solution]

Hi @Inactive User 

It seems to work for me. Can show me whats the error you are getting.

Workflow:

Hope this helps : )

[atcodedog05]

Hi @Sebastiaandb 

It looks like MakeDate() is not an Alteryx function can you check 😅

[Inactive User]

😞