Post

1 follower Follow

Syntax for creating a custom field for % Complete

Our organization would like to calculate % complete differently than Clarizen's stand field of % complete.  We would like to create a custom field calculation that would be total actual effort logged against the project divided by the total number of hours in the work field of the project work plan.  Right now, I have the syntax as \$ActualEffort/\$Work.  However, it is not showing up as a percent.  Can someone tell me how the syntax should read?  thanks!

Hi Virginia,

Did you try to use the custom Field of type "Percent" ?

Yossi Truzman 0 votes

Hi Yossi,  Yes I did.  Please see my attached screenshot.  Is there somewhere else I need to select Percent?

Thanks!

Virginia Hoskins 0 votes

Hi Virginia,

What are you expecting to see on the field level other than a number representing the calculated percent? Is the calculation wrong? or are you after the "%" Symbol?

Yossi Truzman 0 votes

Hi Yossi,

The calculation is right (I think).  There are two problems 1) it is not showing as a percent (it is showing as a decimal) and 2) it is rounding to the first decimal place and I need it to round to the nearest percentage (two decimal places).

I am not sure but I would think if we fix #1, it will take care of #2 right away.

Thanks!

Virginia Hoskins 0 votes

Hi Virginia,

I think I know how to fix it, can you send me a screenshot of the gird on the Project Level with Actual Effort, Work and your field?

Yossi Truzman 0 votes

Let me know if this is what you need or if you need anything else.  Thanks!

Virginia Hoskins 0 votes

As Suspected.

O.k,

First -  You want to Multiply the Calculation by 100

Second - You want to round the calculation to - Set to 0 under "Decimal Places"

Third - You want to Catch the error when there is no value so make sure you don't calculate if \$work=0

I can see this is a POC, but still it is worth getting rid of end cases in the calculation.

Yossi Truzman 0 votes

Yossi,

Thank you so much!!! I have another question not regarding this topic that I will post.

Thank you again!

Virginia Hoskins 0 votes