Reporting, condition of 'is less than'

Wendy Kuo · ‎01-26-2024

Hi,

I am trying to create a report using "is less than' condition. However, I noticed there's is no minutes available as an option to choose from. Even when I try to type in 0.25 hours, it will rounded it off to 0 hours. Is there a way to add minutes to the selection list?

Dr Atul G- LNG · ‎01-27-2024

Hi @Wendy Kuo

OOTB under less than Min is not available. it may be due to background logic. but if you use "Relative" as operator then you can use Min.

*************************************************************************************************************
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]

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

View solution in original post

Dr Atul G- LNG · ‎01-27-2024

Hi @Wendy Kuo

OOTB under less than Min is not available. it may be due to background logic. but if you use "Relative" as operator then you can use Min.

*************************************************************************************************************
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]

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