Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try
Above(sum(closing_amount)) in expression
I cannot use above, at a time am showing only for one date in table.
Can you share the app and also highlight the expected output?
sum({<Date={"$(=Max(Date,1))"}>}ClosingAmount)
This isn't working, is there anyway to automatically take the previous available date
Sorry It should be
sum({<Date={"$(=Max(Date,2))"}>}ClosingAmount)