I am trying to derive at a rolling min/max value over time and have it working for MAX but having problems with MIN.
Specifically the issue is @XRANGE crossing over the years in my app. @MAXRANGE is fine and works perfectly well but @MINRANGE
returns #missing. It does work within the same year.