Expand my Community achievements bar.

KathyLe1
KathyLe1
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hi Catherine, Maybe you could come about it a slightly different way: actualCompletionDate=FIELD:plannedCompletionDate actualCompletionDate_Mod=gt This doesn't allow you any granular control like daysLate=5 would (as an example), but I think it may get rid of your zeros...haven't thoroughly tested, ...

    Type

    Questions

    Views

    711

    Likes

    0

    Replies

    0
  • Hi Stephanie, I think you're on the right track, but you might try this instead: displayname=HrMin textmode=true valueexpression=CONCAT(FLOOR({actualWorkRequired}/60)," Hours ",SUB({actualWorkRequired},PROD(FLOOR({actualWorkRequired}/60),60))," Minutes") valueformat=HTML (Sigh...where's a good Excel...

    Type

    Questions

    Views

    459

    Likes

    0

    Replies

    0
  • Hi Tim, Adding to what Doug and Melinda have said, it's also worth mentioning there are subtle differences between syntax on custom fields (the ones you set up on a custom form) vs calculated fields in reports. If I'm interpreting correctly, I think you are working on a calculated field in a report?...

    Type

    Questions

    Views

    542

    Likes

    0

    Replies

    0
  • Hi Susan, This isn't the least bit elegant, and the performance would probably be unpleasant in a large report, but if you're desperate, I believe the following will work. In a quick test I did where I exported a decent subset of data and compared the results against those of WEEKNUM, everything mat...

    Type

    Questions

    Views

    1.1K

    Likes

    0

    Replies

    1
  • Actually, I think the reason for mine being blank is much simpler. User error! I used Notepad to compile most of my formula (minus listdelimiter), waiting until I popped it in the report to look up the proper delimiter on my cheat sheet. Unfortunately, I copied and pasted from the incomplete one whe...

    Type

    Questions

    Views

    1.3K

    Likes

    0

    Replies

    0
  • There are ways to do this, but the result will depend rather substantially on how your projects are structured. You may end up with more than one active milestone based on your dependencies and where your milestones are applied. If you want to show one line per project, create a project report and a...

    Type

    Questions

    Views

    1.3K

    Likes

    0

    Replies

    0
  • Hi Molly! Sorry your question was overlooked! If I'm understanding what you're requesting, yes this is possible; it just takes a quick jump in and out of text mode to get it to work. I'll get you started with a task report as an example. In your filter window, you want to end up with something that ...

    Type

    Questions

    Views

    300

    Likes

    0

    Replies

    0
  • Glad it worked! I'm happy to help.

    Type

    Questions

    Views

    785

    Likes

    0

    Replies

    0
  • Hi Ondina, With that being the case, I think your best bet is to return to SUBSTR. The following calculation checks to see if there is a ‚Äö√Ñ√∫?‚Äö√Ñ√π in {field} and if so, it will return just the portion between the ‚Äö√Ñ√∫.com/‚Äö√Ñ√π and the ‚Äö√Ñ√∫?‚Äö√Ñ√π. If not, it will just return anythi...

    Type

    Questions

    Views

    785

    Likes

    0

    Replies

    0
  • I‚Äö√Ñ√¥m so glad that helped! And I think you have it! Since we need to tell the RIGHT function, the exact number of characters we want to return from the right of {field}, we first need to figure out the entire length of {field} (since that could be anything). Then we subtract out everything prior...

    Type

    Questions

    Views

    785

    Likes

    0

    Replies

    0
Top badges earned by KathyLe1
Customize the badges you want to showcase on your profile