Post

3 followers Follow
1
Avatar

How to identify duration-type field filled with 0d, 0h, 0w, 0m or 0y in Clarizen Report

Hi Guys,

I am trying to develop a report to do different analysis by pivot-tab (i.e. Different filter by pivot-tab). One of the pivot-tab would show Projects with Custom fields that are not properly filled. The fields are either Text or Duration.

I tried to add a Toggle-type formula field to check all Project Custom fields. However, it is found that '0d','0h','0w','0m','0y' cannot be identified by IsNull in Clarizen (i.e. They are not treated as null value) and Clarizen does not accept something like " $DurationField = '0d' ".

Is there any solution for the case?

Sam

 

Sam Fu Answered

Please sign in to leave a comment.

3 comments

0
Avatar

I think you are looking for $DurationField = Days(0)

You can also use Hours(0), Weeks(0), etc.

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

Josh - It doesn't appear that "Hours()" and the other duration functions are available in reports. I'm trying to write an IF formula in a report and return a result of "0 hours". Trying to use "0", "0h", or hours(0) does not work. What would work in a report? 

Emily Spencer 0 votes
Comment actions Permalink