Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to create a an expression in the front end , that points to the 2nd last value.
So for example, in the simple list of dates below, I want to create say, Sum (Sales), but it where date = 20/03/2018
Date Sales
17/01/2018 20 |
14/02/2018 40 |
20/03/2018 10 |
06/04/2018 90 |
How do i do this?
Kind regards
Nayan
May be this
FirstSortedValue(Aggr(Sum(Sales), Date), -Date, 2)
Thank you Sunny for the quick response. Will try and let you know.
Kind regards
Nayan
Hi Sunny
Doesn't work out, not sure where I'm going wrong. If I just want to show the value in the date field only, so in my case , 20/03/2018
Show in date field? Not sure I understand?... would you be able to elaborate?
Hi
I had a relook at my model and ignore my logic above. I'll resend you my query.
Kind regards
Nayan
How about:
=Max(Date, 2)
or
=Date(Max(Date, 2))
Try this..
=Date(Max(Date, 2),'DD/MM/YYYY')
or
=FirstSortedValue(Date, -Date, 2)
Hi All
Thank you all for your reply. I need to relook at the script. I thought looking at the 2nd most highlest value would solve the actual issue I'm having.
If I get a solution, will share.
Kind regards
Nayan