Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I suppose it's to easy to find, but I'm lost...
In my table I have fields "Max Temperature" (Tempmax) and Date (Xdate).
What I'd like to achieve is to show the Date with the highest 'Tempmax'.
Something like "Highest temperature 34,1 was on 22-7-2013"
Anyone?
See attachment
Fred,
I think the function FirstSortedValue() is what you need. Get the Date value sorted by temperature (negative for descending):
FirstSortedValue(Xdate, -Tempmax)
Regards,
Michael
Fred,
I think the function FirstSortedValue() is what you need. Get the Date value sorted by temperature (negative for descending):
FirstSortedValue(Xdate, -Tempmax)
Regards,
Michael
Another option (see the attached).
If I could, I'd love to give 10 points to both of you but it's not possible 😞
Thanks Michael and Nicole!
See attached
What happens if there are more dates with max temp?
Both solutions fail if there are more than one date with temperature = max(Tempmax).