Skip to content

Budgeted Quantity (with Different Cost Category)

Jun GallardoMember for 18 years 6 months
Created
6
5
0
Hello everyone.

I made a schedule that is resource loaded. My resources include Material and Manpower. Cost Categories are assigned with Material as M and Manpower as L. Normally, adding a new column for BUDGETED QUANTITY in the layout sum up both the quantities of the Material and Manpower resources. My problem is how to add a new column separating both the quantity of the material and that of the labor. I know this is possible in the tabular reports but I want it to be presented in the layout.

Regards.

JUN

6 replies

Oldest first
  1. 0
    Anoon Iimos ·
    if I remember correctly, I think you can use custom data items and make some global changes to suit what you need.
  2. 0
    Jun Gallardo ·
    Anoon,

    Maybe yes, but I tried doing the global change but was unsuccessful after a series of trials. Can you please provide me more details on how to execute your suggestion.

    Regards.

    Jun
  3. 0
    Anoon Iimos ·
    first go to Data, Custom Data Items, create your items, then play with global change
  4. 0
    Jun Gallardo ·
    Mr. Iimos,

    Yes, I know how to use the Global Change, but my main problem is how to provide logic to it applicable to what I need. I tried using the logic for Cost Category but failed. I even filtered first the schedule based on resources containing Cost Cat. of "M" and "L" but was unsuccessful. More help plss....
  5. 0
    Ferdinand U. ·
    Create Data Custom: Assign BQL-Labor BQ & BQM-Mat’l BQ


    for Manpower
    if: CAT eq L

    then: BQL eq BQ (or BC if Cost)

    for Material
    if: CAT eq M

    then: BQM eq BQ (or BC if Cost)
  6. 0
    Jun Gallardo ·
    Dear Ferdinand,

    Thank you. It worked.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?