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

Andrew Payze · ‎09-19-2018

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 · ‎10-08-2018

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

View solution in original post

edo88 · ‎06-24-2021

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

Taha_Alawadhi · ‎04-25-2022

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