Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise 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.

Regarding Actual Qty in Activity Column

4 replies [Last post]
Thu, 2005-11-17 01:37
Kannan KG
User offline. Last seen 15 years 41 weeks ago. Offline
Joined: 22 Oct 2005
Posts: 7
Groups: Petro-Chem / Oil & Gas
I want to use the Actual qty and qty completed in Activity column. I created actual qty and completed qty as custom data item.

And i added qty as Resources and assign qty in the resources, along with the some other resources also, but when i run gloabl change i am not able to select the single resource budgeted qty, it takes all the resources and the last resources buggeted qty is comming as a result.

how i can select single resources value in gloable change,
or any other method to show the actual and completed qty in Activity column.

Thanks in advance,

Regards,
Kannan
Top

Replies

Thu, 2005-11-17 08:03
#1
Jackie Gilliland
User offline. Last seen 14 years 22 weeks ago. Offline
Joined: 17 Mar 2005
Posts: 41
Groups: None
Hi Kannan

I did a quick check, on my first step below, you could actually load your first column by using a global change rather than to have to load it manually.

Good luck

Jackie Gilliland
Top
Thu, 2005-11-17 07:45
#2
Jackie Gilliland
User offline. Last seen 14 years 22 weeks ago. Offline
Joined: 17 Mar 2005
Posts: 41
Groups: None
Hi Kannan

I can quickly think of a solution to your problem but this is a pretty roundabout way, but should work.

create 3 data code fields.
In the first you will need to manually ad your actual quantity of the resource you would like to measure.

leave other 2 blank.

Now create a global change report with.
If: Leave blank
Then:Col 2 = Col 1 * pct

this will give you a value unfortunatly not divided by 100

Create a 2nd global change
If: Leave blank
Then:Col 3 = Col 2 / 100

This is quite an exercise for what you are looking for, so it depends on how seriously you need to do this. There may be shorter alternatives but this is off the top of my head.

good luck
Jackie Gilliland
Top
Thu, 2005-11-17 06:14
#3
Razi Khan
User offline. Last seen 8 years 9 weeks ago. Offline
Joined: 17 Jun 2004
Posts: 74
Groups: None
Hi Kannan,

Can you elabroate little more with example ?

Razi Khan
Top
Thu, 2005-11-17 05:25
#4
MUHAMMAD IQBAL
User offline. Last seen 7 years 7 weeks ago. Offline
Joined: 29 Aug 2005
Posts: 34
Groups: Planning, Claims & Contracting, TILOS
use logic in globle change and run

have fun

Top