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
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