AnsweredAssumed Answered

Creating a calculated field with negative values

Question asked by dominicjoannou on Nov 8, 2016
Latest reply on Nov 8, 2016 by David Moyer

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

Outcomes