Comments
-
Haven't quite got the numbers adding up yet, but I managed to get rid of the Unknown by adding an extra line: WHEN `Adjusted Business Go-Live 1 Date_p` IS NULL AND `Initial Business Go-Live 1 Date_p` <= DATE_SUB(CURDATE(), interval 25 day) then 'On-Time'
-
I think I see the problem, ignore me for a minute :)
-
Understood. Any other ideas? Have a chance to look at the file? Is there a quick way to look at the specific projects/dates it's identifying as Unknown, Overdue, etc. And again, thank you so much for your help. Massively appreciated.
-
Hi Grant, Stared at this for a while. If more than one line is true, is it causing issues? For instance, these can both be true: The adjusted can be </= to 25 days after Initial (On-Time) The adjusted can be > 25 days after today (Overdue) Thanks
-
Hi Grant, Sorry, you were too fast; I got it working and added an edit above. I'm not exactly sure what the problem was, but I will call it user error :) I tried to strip out the comments too, so this is what got it running for me: CASE WHEN `Actual Business Go-Live 1 Date_p` IS NULL THEN CASE WHEN `Initial Business…
-
Hi Grant, Happy Monday to you. Back on this today. Understand the commenting method now. Silly me. EDIT: Deleted this, as I think I may be making progress. Further update soon….
-
Hi Grant, Backticks just don't paste into the forum for me, but I think I have those per screenshot? Though I am a bit confused, your lines 2, 4, 8, 10 don't have backticks either, while others do?
-
Hi Grant, Thank you so much! First, I should have expressed how I am completely new to Beast Mode, and my coding experience has been almost zero since I graduated college 20+ years ago. I suspect you wanted me to convert a few of these lines into more codey things, but that might be beyond me :) I apologize for the stupid…
-
Wow, that reply was incredibly fast!!! And it works; thank you so much; I didn't realize it would be that simple!
