Syntax for creating a custom field for % Complete

Hi Virginia,

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

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

Thanks!

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?

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!

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?

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

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,

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

Thank you again!