1 Reply Latest reply: Jan 18, 2013 8:53 AM by 883455 RSS

    @MINRANGE with @XRANGE issue

      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.

      Any thoughts?

      This Works:

      @MAXRANGE ("Exclus",@XRANGE("FY12"->"Dec", "FY13"->"Jan"));

      This Doesn’t:

      @MINRANGE ("Exclus",@XRANGE("FY12"->"Dec", "FY13"->"Jan"));

      The @XRANGE also works with @SUMRANGE

      I have tried various variations without any success