Can we calculate the variance (days) between project task and the baseline date

[Andrew Payze]

Hi,

We want to be able to report on the variance between the baseline value for say Finish date and the task planned finish date.

I have built a report using the planned_task_baseline_item.  This report lists the two fields I want, now I want to calculate the variance.

Could I create a database view, can you add a calculated type field to a database view?

Any ideas?

Tx

Andrew Payze

[Brian Gadeberg · Accepted solution]

Hi Andrew,

I would suggest to look at the functionality on the financial baseline and create the same(+) for schedule baseline. On the Financial Baseline the baseline values are compared with the Current.

You could do the same for scheduled baselines and add two new fields - one for "Actual end date" and one like "End date varians".  Then create a functionality to calculate the varians after the baseline is created - I think it could solve your challenge. I would recommend to execute the calculations on the schedule baseline table.

Hope this helps you

Brian 

[Andrew Payze]

Hi Brian,

Thanks for this … will taker a looks at the Financial Baseline.

I assume when you are referring to "Create a functionality". this would be a script?

Regards and thanks

Andrew

[Brian Gadeberg]

Yes 🙂

[edo88]

I noticed that actuals benefits, for example, are not considered OOTB, which is strange.

I created the field in the baseline table and completed the mapping/configuration and now it's perfectly stored ... however doing a compare still shows the field empty no matter what 😞