Hi,
As an example, I have the following list of values:-
Date.........Total
1JAN18 6
2JAN18 5
3JAN18 0
4JAN18 1
5JAN18 5
Using a calculated field, how can I return the 'Total' from the second from last date (answer being 1?)
In fact, how would I return the 'Total' from any given specific date?
Regards.
10 answers
see the attached
this will find the max time date
this is the difference to the max in each code
thins will isolate the next to last
and this returns the value
and this is the results
Jim
If this resolved you issue please mark my response correct
