Post

2 followers Follow
0
Avatar

Cumulative totals on financial time-phased report

On the Financial time-phased report would it be possible to have cumulative Budget and Actual figures, so that we can plot the actuals against budget to-date. At the moment you can only get current actuals against the overall total budget.

Jeremy Tiley Answered

Please sign in to leave a comment.

2 comments

0
Avatar

Hello Jeremy, 

Do you mean like this?

I hope this helps.

Best regards,

Roland

Roland Pumputis 0 votes
Comment actions Permalink
1
Avatar

No, not quite. What I am after is a total of actual cost to-date against the total budget cost to-date. What the standard reporting provides is just the actual cost and budget per month and not running totals. The Actual Cost to-date and actual revenue to-date are easily available, but the budget amounts aren't.

I have found a solution for it by creating data snapshots using the GetTotalFinancialSummaryForGivenPeriod() function e.g.

Budget Cost to-date = GetTotalFinancialSummaryForGivenPeriod(CurrentObject(),'PlannedBudget',$StartDate,Today())

Budget Revenue to-date = GetTotalFinancialSummaryForGivenPeriod(CurrentObject(),'PlannedRevenue',$StartDate,Today())

I can then plot these against the actuals (also snapshot'ed). This gets me what I need for now.

Jeremy Tiley 1 vote
Comment actions Permalink