Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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

Avatar

Level 2

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