Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add Group Diff Minimum Date

Status
Not open for further replies.

codrutza

Technical User
Mar 31, 2002
357
IE
Please help. I have a report in which I group by User and Ourref. At the level Ourref I take minimum date because I have to pick from Logdate from many records the one who has minimum date

DATEDIFF('d',Minimum ({T;1.PostedDate}, {T;1.OurRef}),
Minimum ({T;1.Logdate}, {T;1.OurRef}))

And I have to add at Ourref level and at User Level.

How can I do this?
User: Amadeus and Ourref: 342, 244, 545:
LOGDATE POSTEDDATE
Amadeus
342 13/05/2016 10/05/2016
15/05/2016 10/05/2016
MIN 13/05/2016 10/05/2016

244 06/05/2016 02/05/2016
MIN 06/05/2016 02/05/2016

545 11/05/2016 03/05/2016
11/05/2016 03/05/2016
04/05/2016 03/05/2016
MIN 04/05/2016 03/05/2016


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top