1 Reply Latest reply on Jan 19, 2010 10:47 PM by RickWhitelaw

    Sorting and Reporting Negative Number

    PWGKing

      Title

      Sorting and Reporting Negative Number

      Post

      Using FMP 10 Adv I wish to sort and report negative numbers. Fields used are as follows:

       

      "Days Until Inspection Due" - will be negative when todays date has past the "Inspection Due Date".

       

      Thanks for your time.

       

      PWGKing 

        • 1. Re: Sorting and Reporting Negative Number
          RickWhitelaw
            

          Sorry to be facile but it's all the same . . . positive integer or negative integer. Handling negative numbers is no different than handling positive ones. Depending on your needs you may decide to sort in ascending or descending order. i.e. if you sort by ascending order "-2" will come before "3".

           

          RW