@skyehansen thanks for your reply! I took your advice and adjusted the formula to the following, but this time it's generating no results. thoughts? displayname=Cycle Time Variance from SLAvalueexpression=SUB{{DE.project.program.PIM | Program SLA Sum},{DE.PIM | Task Cycle Time to In Market Date - Wo...

Hi Friends! In a project level report, we are trying to create a custom column that portrays the difference between 2 custom fields. The below are the custom fields (their names in bold, sentence below is how the custom fields are calculated): PIM | Task Cycle Time to In Market Date  - Work Min Diff...

Hi Everyone, I have a general question. What is the difference between the project entry date and the project submission date? Thanks!

@skyehansen this was perfect, thank you so much!!!

Thanks for your response! Summary section, minus the count column, is the look my stakeholders want but it doesn't look that way when the report is emailed to them on a monthly basis since it reverts to the detailed section view.

Hi everyone! i am working on an Assignment report for a project team so they can see all the completed projects they were assigned to. This report is based on the $$User so it'll be a custom view for whomever opens the report. If a user was assigned to multiple tasks in a project it will show up mul...

ah, thank you!

didn't work, looks like the system keeps reverting back the value format to it's original form, "compound#M:D": displayname=Actual Duration (no days)linkedname=directnamekey=actualdurationquerysort=actualDurationMinutestextmode=truevaluefield=actualDurationMinutesvalueformat=compound#M:Dviewalias=ac...

Could someone share the text mode needed to display the Project Actual Duration without "Days" in the result? This will save us a step in excel so we don't need to delete all the "days" in this column.

Got it to work! the Owner filter I used was actually the owner of the document, not the project. One last question if you don't mind. I tried adding in the following text mode to filter to the Project level owner of the project itself, but i keep getting an error message. Any advice on how this coul...