Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Journal Entry Report Help: Only the latest field change in a date range and preventing duplictes

Avatar

Level 3

I have built a Journal Entry report to pull the project budget number (greater than 0) if edited this week.  My two questions for the community are:

  1. How can I only pull the last budget field update (if someone updated the field multiple times in the week, I only want the max/latest change, not all)?
  2. How can I prevent random duplicate rows (several changes are complete duplicates with the same date/timestamp repeated up to 42 times, but some changes don't duplicate at all)?

In the attached image, 2 budget entries for 2 separate projects duplicated but one project (in the middle) reflects the accurate single row. 

 

Dupes1.pngDupes1 Text Mode.png

2 Replies

Avatar

Level 4

Hi,

Did you maybe already find a solution for only showing the latest edit row?

Kind regards,

Femke

Avatar

Level 3

Unfortunately I have not.