4 Replies Latest reply on Feb 5, 2014 7:12 AM by NicolasFasel

    perform and keep sorted



      perform and keep sorted


      FileMaker Pro


      12 advanced

      Operating system version


      Description of the issue

      I would like to obtain the maximum of a calculated field, from a related layout.

      I need to calculate the time elapsed between two date:
      Date - GetNthRecord( Date ; Get ( RecordNumber ) - 1)

      But when this calculation is obtain from the original layout, the dates remain unsorted. It results some negative value...

      If I perform find on the layout with the calculation, the sorting is also not kept...