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!
Please sign in to leave a comment.
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
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.