4 Replies Latest reply: Apr 17, 2015 4:41 AM by Andrew Whitfield RSS

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

    Maarten Van Damme

      Hi,

       

      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))

       

      example.png

       

      All suggestions are welcome!

       

      Regards,

      Maarten