Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Query to get total planned cost/actual cost for each buget line

Highlighted
Phanishwar
Collector

Query to get total planned cost/actual cost for each buget line

Hi,

For a project there is requirement to pull total planned and actual cost per/individual buget line for both labor and non labor . I am wondering if it can be pull directly. is there any api by ppm to pull the same.

I need the sql for list portlet.

Thanks ALL for you immense support till now!!.

Thanks,
Phani
2 REPLIES
Phanishwar
Collector

Re: Query to get total planned cost/actual cost for each buget line

see the doc attached
Phanishwar
Collector

Re: Query to get total planned cost/actual cost for each buget line

I think i got it.

SELECT
sum( c.PLAN_VALUE_BSE),
sum( c.ACTUAL_VALUE_BSE)
FROM kcst_currency_cells c, kcst_budget_line_cells b
WHERE c.CURRENCY_CELL_ID = b.CURRENCY_CELL_ID
and budget_line_id=35280.

I thought it's not direct.

//Add this to "OnDomLoad" event