Workflow if Field Is Not 0

Morning all,

I want an email to be sent if a Milestone is closed but the Invoice Amount field is not 0.

So far I've got:

IsChanged($State) && $State='Completed'

But I'm not sure what the script is to check if the value of the field is 0.

Thanks for any help

Martin Jubb March 04, 2020 06:58 Answered

Please sign in to leave a comment.

Hello Martin,

You can use this, if the Invoice Amount field is a currency field: $InvoiceAmount = Currency(0)

Or this, if it is a number: $InvoiceAmount = 0

I hope this helps.

Roland

Roland Pumputis March 13, 2020 08:20 0 votes

Thanks Roland,

I think that checks if the field is 0. What if I wanted to check that its is Not 0?

Cheers

Martin Jubb March 28, 2020 07:49 0 votes

Hi Martin,

Then you can use $InvoiceAmount <> Currency(0) or $InvoiceAmount <> 0

Roland Pumputis March 28, 2020 07:51 0 votes

Thanks Roland

Martin Jubb March 28, 2020 07:58 0 votes