Sum the value of previously available date

[Anonymous]

Hi,

I have data like below,

Date               closing_amount

22/03/2018           100

23/03/2018            1000

26/03/2018           500

27/03/2018            100

For each date I am creating new column which is previous day's closing amount.

If previous date is not there, then it should take previous to previous date, which i have achieved through variables.

But, how to dynamically find the previous available date in front end and use in set analysis.

sometimes the date difference be 3 or 4 , how to find the previous available date's closing_amount.

[shiveshsingh]

try

Above(sum(closing_amount)) in expression

[Anonymous]

I cannot use above, at a time am showing only for one date in table.

[shiveshsingh]

Can you share the app and also highlight the expected output?

[sasiparupudi1]

sum({<Date={"$(=Max(Date,1))"}>}ClosingAmount)

[Anonymous]

This isn't working, is there anyway to automatically take the previous available date

[sasiparupudi1]

Sorry It should be

sum({<Date={"$(=Max(Date,2))"}>}ClosingAmount)