Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get the expression by max(snapshot_date) ?
PFA.
The max(snapshot_date) is 2014-09-09 00:00:00.000 .
I want to show Current Forecast = 800
JE Forecast = 800
which is the value for the latest snapshot.
As, for Fiscal Month : JUL it is having 2 snapshot_date i.e 2014-09-09 00:00:00.000 and 2014-09-03 00:00:00.000.
Thus, now it is adding the values of both snapshot.
My requirement is to get the latest value of the max(snanshot).
=FirstSortedValue(Current_forecast,-snapshot_date)
Yes it worked..
But I want the Total also .
