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