decimal in percentage complete column

S
Sajid Balma 👤 Member for 19 years

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

A
Anbin Ponnith 👤 Member for 17 years

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

S
Sajid Balma 👤 Member for 19 years

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

S
Sajid Balma 👤 Member for 19 years

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

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts