5 Replies Latest reply on Nov 5, 2015 4:01 AM by karolina.drewnik.0

    Minimal value of several parameters

    karolina.drewnik.0

      Hello,

       

      I created calculated fields for dates from several tables - results are integers.

      They look like this:

      DATEDIFF('day', MAX([Date (table1)]), TODAY())

      DATEDIFF('day', MAX([Date (table2)]), TODAY())

      ...


      Now in Calculated field I want tot choose minimal value of the result of this parameters.


      My idea was to sort that and take last value but still I am not sure how to do that.

      Do you have any better ideas?


      Best wishes,

      Karolina