Regarding Actual Qty in Activity Column
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
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
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
Hi Kannan,
Can you elabroate little more with example ?
Razi Khan
use logic in globle change and run
have fun