4 Replies Latest reply: Apr 17, 2015 4:41 AM by andy whitfield RSS

    Get min and max possible value in specific field based on current selections



      I was wondering if it is possible to get the minimum and the maximum possible value in a specific field (in which no selections have been made), based on applied filters on other fields.

      Attached an example. The goal is to obtain the value 2014/03/01 for min and 2014/10/01 for max.


      I tried with FieldValue, but that did not work as expected.

      e.g. ='Lowest possible date value: '  &min(FieldValue(Date,1))




      All suggestions are welcome!