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
-
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?
-
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.
-
Fred
Hi Fred, there any Formula that can incluyde the Cost sum on the Field Actual_Cost_Act. (Now I place manually)
-
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'
-
Fred
Not Fred sorry,
Cost_V = Earned_V - Actual_Cost_Actand 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.
-
-
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?
-
Fred
I send you the DB take a look if you have time and excuse the abuse.
. -
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.
-
Fred
As easy as that, God I don't learn anything.Thanks Fred sorry agai
-
You are welcome.
