0

SUM COST By CUTOFF_DATE

Fred

Hi Fred I hope help with that.

On the EVM Table I have the KPI' Activities Form in that form have the Field Actual_Cost here I charge the accumulated cost Week by Week in each activitie (need that for calculate the KPI's) but I need to charge the cost Week by Week (each week of cutoff date ) no accumulate, is  for sum the cost of each week.

 

In the KPI' PROJECT have all the info for the KPI' Project 

10replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    I'm not sure I understand what the question is. It sounds like you want to have a weekly breakdown of costs. That means you have to have a table that tracks cost by date, meaning there is a record that a specific date data and a specific cost data. Do you have that data? If you do what is the table name and the field names?

    You have a table called cutoff-dates. Do you want to use those dates?

    Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    Fred

    Yes I want a weekly Breakdown of Cost.

    Now I place the cost in the EVM Table on the KPI' Activities Form in that form have the Field Actual_Cost here I charge the accumulated cost Week by Week,( now I place cost from Activities 6 to 10)  (in the activitie 6, I charge cost 575.95€ next cutoffdate 575.95 + xxxxx accumulated) don't like that need charge by cuttoffdate.

    Yes I have a Table for all cutoffdates.

    I try create a cost Table, and work on embedee View but is cpmplicated.

    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    Fred

    Hi Fred, there any Formula that can  incluyde the Cost sum on the Field Actual_Cost_Act. (Now I place manually)

    Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    Is the costo_w table on KPI Activities a view element? If so then you would use a similar formula to sum the total of costs for 'Actual_Cost_Act'

    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      Fred 

      Not Fred sorry,

      Cost_V =  Earned_V - Actual_Cost_Act

       and for now Actual_ Cost_Act is place manually.  

      The Actual_ Cost_Act is need for Cost_V and CPI Formulas

      I try that      first((select COSTO_W).Cost)      but bring any value.

      Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    According to your picture Actual_Cost_Act looks to be equal to the sum of costs from Costo_W. If that is true then you can do a sum of cost from Costo_W, but if you do a select you need to filter it so that is why I ask before about the relationship between the two tables. Can you filter by activities?

    Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    Fred

    I send you the DB take a look if you have time and excuse the abuse.🙁.

    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    In the KPI Activities tab, change the code in field Formula 2 to:

    sum(COSTO_W.Cost)
    

    It is good that Costo_W is a related field.

    Like 1
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    Fred

    😂 As easy as that, God I don't learn anything.

    Thanks Fred sorry agai

    Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    You are welcome.

    Like
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 10Replies
  • 36Views
  • 2 Following