how to calculate aging (select earliest & latest date in a list) urgent !!!

[Anonymous]

ID	Class	Created
2014	Class A	3/17/2015 11:14
2014	Class A	3/16/2015 9:49
2014	Class A	2/14/2015 7:29
2014	Class A	12/11/2014 4:42
2014	Class B	3/13/2015 15:56
2014	Class B	2/10/2015 14:50
2014	Class B	10/10/2014 15:52
2014	Class B	1/1/2015 13:12
2014	Class C	3/3/2015 15:38
2014	Class C	3/3/2015 14:44

Need help on how to solve this problem.

I want to select the earliest date for class A & latest date from class B & C to calculate the aging.

Example:

If Aging A to B, A should be 12/11/2014 4:42 minus B 3/13/2015 15:56.

If Aging A to C, A should be 12/11/2014 4:42 minus C 3/3/2015 15:38.

Kindly help. Thanks.

[robert_mika]

The latest C is 3/3/2015 14:44 so why 3/3/2015 15:38?

[Anonymous]

Hi robert, latest means the new one created.

[#4]

Aging B-A

=Max({<ID={2014},Class={'Class B'}>} Date(Created)) - Min({<ID={2014}, Class={'Class A'}>} Date(Created))

Aging C-A

=Max({<ID={2014},Class={'Class C'}>} Date(Created)) - Min({<ID={2014}, Class={'Class A'}>} Date(Created))

[robert_mika · Accepted solution]

Do you want to choose yourself or that should be always there?

B

=max({1<Class={'Class B'}>} Created)-min({1<Class={'Class A'}>} Created)

C

=max({1<Class={'Class C'}>} Created)-min({1<Class={'Class A'}>} Created)

[#6]

• Hi ahmad,

could you please explain how the selection should be for your ageing?

[Anonymous]

thanks robert

[ankitaag]

B-A

=Max({<ID={2014},Class={'Class B'}>} Date(Date#(Created,'MM/DD/YYYY hh:mm'),'MM/DD/YYYY')) - Min({<ID={2014}, Class={'Class A'}>} Date(Date#(Created,'MM/DD/YYYY hh:mm'),'MM/DD/YYYY'))

C-A

=Max({<ID={2014},Class={'Class C'}>} Date(Date#(Created,'MM/DD/YYYY hh:mm'),'MM/DD/YYYY')) - Min({<ID={2014}, Class={'Class A'}>}Date(Date#(Created,'MM/DD/YYYY hh:mm'),'MM/DD/YYYY'))