Regarding Actual Qty in Activity Column

K
Kannan KG 👤 Member for 20 years 7 months
J
Jackie Gilliland 👤 Member for 21 years 2 months

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

J
Jackie Gilliland 👤 Member for 21 years 2 months

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

R
Razi Khan 👤 Member for 21 years 11 months

Hi Kannan,



Can you elabroate little more with example ?



Razi Khan

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts