Hi Sven,I am looking for projects in a specific status to see if an issue doesn't exist when that status is used and when I copy/pasted your code into the text mode report, the results weren't correct. I do have a portfolio filter, program filter, etc. on my report and when I used that native option...

Hi Sven,I gave that a shot and the results that appeared were inaccurate. But when I did a project report and used the native "Number of Open Issues Equal (Case Sensitive) 0," then I got what I needed. Thanks for your assistance and input!Mary

Hi Sven,You're correct, that's why I didn't built it as an Issue report. I attempted to use text mode and use the not exists options you noted and it didn't work. I found an alternative option, using ChatGPT actually, to search for projects in that status and if the number of open issues equals 0, t...

Hello,We have users that are associating a custom project status and when they select that project status, they're supposed to enter an issue within the project with that status. I'm trying to build a report to see when projects have that status, show me only when the issue doesn't exist. It's basic...

Hi @ConnorO2 and @shane_mckinney ,We've been experiencing this in our instance since we migrated to Unified Experience mid August. We were on the Console since April of 2023 and had zero issues. We do have a support case open but the ASE has been incredibly frustrating and not helpful in his "resolu...

Hi Rich,Got it and changed my duration field to number and that worked! Do you have a good "rule of thumb" of when a calc field is text vs. number depending on what you're looking to do? Just trying to make sure I don't make that mistake again in the future and catch that up front. I appreciate your...

Hi Rich,This is fantastic and SO helpful! I went with your second option and it seems to have worked in several cases but in others, it didn't. For example, attaching screenshots, some of the actual durations would fall in either the 30 or 30-60 range but are going into the 90+? Not sure why that is...

Hello,We have a user looking for a project report that groups the data in a chart by project actual duration and we know we need to make a calculated field, put that on a form on the projects to get that information. However, in a bar chart, that pulls in every possibly calculation and we'd like to ...

Actually sorry, we got the calculation right but now we need to basically add to the grouping that we need to have the actual completion date in period of time like 0-30 days, 30-60 days, 60-90 days, 90+ days. I think we need to add an aggregator to that calculation but I've never done that. Any adv...

Hi Emma,We are running into the EXACT same situation. Can you provide a screenshot, or advise us, on what calculation you put into the Calculated Custom field to get this data? Thanks!Mary