I need to extract budget, cost, Actuals & Variance for current fiscal year and Total lift cost for preparing status report.
Could anyone suggest with sample datas/query, Do we have an option to extract all the values?
|Budget||Cost from Budget plan of record||For CAPEX line, Cost type = CAPEX For OPEX line, Cost type = OPEX For “Current FY” column, sum for the FY corresponding to the report date For “Life totals” column, sum the total for all Fys|
|Forecast||Costs from cost plan of record - Total Actuals||Above rule|
|Landing||Costs from cost plan of record||Above rule|
|Variance||Costs from cost plan of record - Costs from Budget plan of record||Above rule|
|Input in Red if >0|
Input in Green if <= 0