Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

decimal in percentage complete column

4 replies [Last post]
Wed, 2009-08-12 08:26
Anbin Ponnith
User offline. Last seen 9 years 9 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top

Replies

Sun, 2009-08-16 10:02
#1
Sajid Balma
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 8 Jun 2007
Posts: 151
Groups: None
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
Top
Sat, 2009-08-15 04:44
#2
Anbin Ponnith
User offline. Last seen 9 years 9 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top
Thu, 2009-08-13 07:47
#3
Sajid Balma
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 8 Jun 2007
Posts: 151
Groups: None
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
Top
Thu, 2009-08-13 07:41
#4
Sajid Balma
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 8 Jun 2007
Posts: 151
Groups: None
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
Top