Post

2 followers Follow
0
Avatar

How to write "Work" > 0

I am trying to write a workflow rule that fires when total work for the project is greater than zero. However, it says that the ">" function cannot be used with Numeric or String values. So, how do I tell the system to look at this criteria?

The closest I got was "Not(IsNull($ParentProject.Work)." The syntax works for this, but, obviously, "0" isn't considered Null, so I need the additional criteria.

Thanks!

Peter Zovath Answered

Please sign in to leave a comment.

2 comments

0
Avatar

You might try this: $Work > Hours(0) . The key is that $Work is type Duration, kind of counter-intuitively. :) You can use math on Duration vs Duration but not always when mixing types like Numeric vs Duration.

Jeff

Marketing Mojo IT 0 votes
Comment actions Permalink
0
Avatar

Thanks Jeff! I also got the following response from Clarizen:

Tostring($Work)>”0"

This also worked for our purpose in case anyone needs another option.

Peter Zovath 0 votes
Comment actions Permalink