Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Test:
LOAD * INLINE
[myDate, Utilisation, Capacity (23.3TB)
25/07/2016, 92.62, 22.105
01/08/2016, 91.69, 21.883
08/08/2016, 91.08, 21.738
15/08/2016, 91.38, 21.809
22/08/2016, 91.85, 21.921
29/08/2016, 91.85, 21.921
07/09/2016
08/09/2016
10/09/2016
];
Imagine myDate is infinite. I would like to get the last Utilisation figure 91.85 without explicitly saying myDate= 29/08/2016
I am trying to get the logic behind it.
//sum({< myDate >}Utilisation
Hi David,
try:
=FirstSortedValue({$<Utilisation ={">0"}>}Utilisation,-myDate)
Kind regards
Andrew
Hi David,
try:
=FirstSortedValue({$<Utilisation ={">0"}>}Utilisation,-myDate)
Kind regards
Andrew
try this in front end
=FirstSortedValue(Utilisation,-myDate)
Try This,
=sum({<myDate = {"=Max(Date)"}>}Utilisation)
try this
=sum({<Date={"$(=date(max({<Utilization={">0"}>}Date)))"}>}Utilization)