RE: Saved Search Formula Not Working
Hello! I’m working on cleaning up and updating a saved search for resource forecasting that a predecessor set up. It is set up to look at an event start and end time for an employee and if they have an event at that time to show “NA”. However for the 8:00-8:15AM (converted to decimal) time bucket and a couple other time buckets, the formula doesn’t work, (shows “A” when should be “NA”) but works for the majority of them. I’ve checked the event set up and nothing sticks out as being off as well as adjusting the number of decimal places.
CASE
WHEN {starttime}- TRUNC({starttime})=0.333333333333333 OR (0.333333333333333>{starttime}- TRUNC({starttime}) AND 0.333333333333333<{endtime}-TRUNC({endtime}))
THEN ‘NA’
ELSE ‘A’
END
Thanks for your help in advance!
Hi Chris,
I agree, there is probably a much easier solution but not looking to recreate the wheel on this one with my limited knowledge of SQL/javascript! Your solution fixed the issue for the 8AM time bucket so going to update all of the formulas to use minutes vs decimals and that should fix the issue I’m running into!
Thank you so much for your help with this!
