cancel
Showing results for 
Search instead for 
Did you mean: 
rstrole
Nintex Newbie

Getting different results from two formulas that should be the same

Nintex noob here. Just spent a bit of time figuring this out but I am curious as to why one formula works and one does not:

This works:

fn-If(fn-Or(fn-IsNullOrEmpty(Stage),fn-Equals(Stage,'1')),false,true)

This doesn't work (it always comes back false but should be true if stage is anything but null or 1):

fn-Not(fn-Or(fn-IsNullOrEmpty(Stage),fn-Equals(Stage,'1')))

0 Kudos
Reply
1 Reply
Automation Master
Automation Master

Re: Getting different results from two formulas that should be the same

That's a good question, it seems like it should do as you expect. I'll try to run it in a workflow to check, but here is my expectation to match yours.

Stage = Null THEN FALSE(TRUE(TRUE,FALSE))

Stage = 1     THEN FALSE(TRUE(FALSE,TRUE))

Stage = 2     THEN TRUE(FALSE(FALSE,FALSE))

And on another note, you could run it as a short circuit using the following function that may be easier to manage.

fn-If(fn-IsNullOrEmpty(Stage), false, fn-If(fn-Equals(Stage,'1'), false, true))

Reply