need to know the condition for compairing the change report

anuragkumbh
Tera Contributor

need to know the condition for comparing the change report for Actual Start time, planned start time vs Actual end time, planned end time.

Suggestion would be appreciated.

6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @anuragkumbh 

 

It depends on what exactly you want to achieve. 

 

Actual start time always greater than Plan Start

and 

Actual end always less than Plan end.

 

If you provide more details , will able to help you.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi,

 

Thanks for your response.
Below are the more details which I need to achieve.

 

Please overdue Change report, all CR which are closed outside Planned schedule i.e. Actual start time if before Planned Start and Actual End time if after Planned End time, those CR should reflect in report.

Hi @anuragkumbh 

 

 

try this way

 

AGLearnNGrow_0-1732622211078.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Request you to please provide with complete condition to follow and try as i am new to this.