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 derfloh 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
Joined
Mar 31, 2002
Messages
357
Location
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


 
I must be missing something. Can't you just insert the formula?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top