question Re: Can we calculate the variance (days) between project task and the baseline date in SPM forum

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

Andrew Payze — Wed, 19 Sep 2018 15:25:49 GMT

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?

Andrew Payze

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

Brian Gadeberg — Mon, 08 Oct 2018 13:53:18 GMT

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

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

Andrew Payze — Mon, 08 Oct 2018 19:17:32 GMT

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

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

Brian Gadeberg — Mon, 08 Oct 2018 19:33:02 GMT

Yes 🙂

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

edo88 — Thu, 24 Jun 2021 10:45:06 GMT

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 😞

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

edo88 — Thu, 24 Jun 2021 11:06:55 GMT

I noticed the problem is the prefix "u_", you can bypass that using this:

https://community.servicenow.com/community?id=community_question&sys_id=432ec3eddb9cdbc01dcaf3231f96196c

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

Taha_Alawadhi — Mon, 25 Apr 2022 21:20:44 GMT

@edo88 how did you create your variance report? can you help me with that please?