Journal Entry Report Help: Only the latest field change in a date range and preventing duplictes | Adobe Higher Education
Skip to main content
SLuna74
Level 3
January 19, 2023
Vraag

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

  • January 19, 2023
  • 1 reactie
  • 806 Bekeken

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. 

 

Er kunnen geen reacties meer worden geplaatst op dit onderwerp.

1 reactie

Level 4
November 28, 2023

Hi,

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

Kind regards,

Femke

SLuna74
SLuna74Auteur
Level 3
November 28, 2023

Unfortunately I have not.