1 Reply Latest reply on Nov 8, 2016 4:40 AM by David Moyer

    Creating a calculated field with negative values

    dominicjoannou

      Hi All,

       

      I have been creating a layout table which keeps track of all pended cases for my research.

       

      This layout table is comprised of:

       

      If(IsEmpty(Date of Expiry of Review of Sanction Due Overdue); ;""; (Date of Expiry of Review of Sanction Due Overdue - Current Date)) *as an unstored calculation

       

           

      Research Data Table::Date of Expiry of Review of SanctionResearch Data Table::Date of Expiry of Review of Sanction deletedResearch Data Table::Date of Expiry of Review of Sanction Due Overdue
      26/02/2018475

       

      I have already have conditional formatting on the due overdue day number  eg "475" where this text would become red at -1 when overdue.

       

       

      I would like to take this one step further.

       

      I would like to create a new field with only negative numbers from the Date of Expiry of Review Sanction Due Overdue.

       

      This is to have this new field to be used in a layout report of people whose sanction dates are overdue. The end result, if I am putting in the dates and deleting them as appropriate is that Filemaker would literally do all the tracking for me.

       

      How do I create this new field?

       

      Many thanks

       

      Dominic Joannou