Set Analysis Calculation of Lost Amount based on MAx(date) and the date Before it direcctly
hi Pardib this my sampl Data i used your Expression it works but my request is i need to show a table that calculate the amount in max date VS the amount in the Previous date right before it here is my example:
ID
Balance
Date
07019
20994.09
3/19/2015
07019
21035.58
11/26/2014
07019
21077.07
12/31/2013
07019
20007
1/31/2014
07019
17000
2/28/2014
07019
18000
4/30/2014
07019
12000
5/31/2014
07019
10000
6/30/2014
07019
14000
7/31/2014
07019
25000
8/31/2014
07019
55000
9/25/2014
07019
153000
10/17/2014
00534
144551
3/19/2015
00534
153420
11/26/2014
00534
161708
12/31/2013
00534
25000
1/31/2014
00534
26000
2/28/2014
00534
29000
4/30/2014
00534
35000
5/31/2014
00534
45000
6/30/2014
00534
26000
7/31/2014
00534
29000
8/31/2014
00534
22000
9/25/2014
00534
21000
10/17/2014
in this Case i need my output will show if no selection on any field the Amount on max date VS the previous one in my example :
ID MaxDate (3/19/2015) PreviousDate(11/26/2014) Lost Amount
07019 20994.09 21035.58 20994.09-21035.58=(41.49)
00534 144551 153420 153420-144551=8869
if i select on for example 10/17/2014 i get
ID MaxDate (10/17/2014) PreviousDate(9/25/2014) Lost Amount
