Skip to content

decimal in percentage complete column

Anbin PonnithMember for 17 years 4 months
Created
4
4
0
Is there any possible way to display decimal values in the percentage complete column.

As my project value is 600 million SAR some times the displayed percentage is questioned by our clients.( if its 4.51 it shows as 5 % complete) So overall it gets affected.


Is there any possible solution.,

Regards,

Anbin Ponnith

4 replies

Oldest first
  1. 0
    Sajid Balma ·
    Hi Anbin
    You need to create a CDI say its ID is PRCT & name as MyPercent. The data type should be PRECISION.

    Add this PRCT column in your layout beside % column.

    Now run a Global Change with the following syntax

    In Top window
    If PCT NE 100

    Bottom Window
    PRCT EQ PCT

    In this case if you have any proress % like 80.3, the PRCT will display as 80.3. Now you can hide the % column & rename the title of PRCT column as %. You would have your desired data displayed.

    Regards
  2. 0
    Sajid Balma ·
    I am sorry to mention the imp thing.

    P3 still calculates the cost/Resource on the % to 1 decimal place. So, if it is 80.3, although the % clo shows 80, the quantities or costs are calculated on 80.3 percent.

    Regards
  3. 0
    Anbin Ponnith ·
    Dear Sajid,

    I tried and for most of the activities it got changed execpt for some showing,

    "Overflow/Underflow condition, custom data item not changed"

    So the overall percentage comes error.

    Regards,

    Anbin Ponnith
  4. 0
    Sajid Balma ·
    Dear Anbin
    CDI does not react the same way as any other default column of P3. So, no surprise to me.

    Please be noted that CDI will not give you a cummulative progress on any of the bands, since it is not a deafualt colum, it does not know what to do on the bands.

    Regards

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?