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
• 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.

Like
• 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..

Like
• 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