1 Reply Latest reply: May 15, 2014 9:58 AM by Grant Perkins RSS

    NEGATIVE VALUES IN BRACKETS

    GEORGEDIMSDALE _

      Monarch 7

       

      My report has negative numbers formatted as follows:  ($1,234.56)

       

      How can I get Monarch to recognize these as negative numbers? It properly extracts positive numbers formatted as $1,234.56, but won't recognize the brackets as indicating negative numbers, so skips the field.

        • NEGATIVE VALUES IN BRACKETS
          Grant Perkins

          I would expect Monarch to recognise those field as negative though there may be some combination of circumstances that means it does not.

           

          First question - is your field wide enough to include the brackets when capturing? If the answer to that is yes then we need to look for something less evident.

           

          Also is the field being captured as a numeric value or something else? Silly question maybe but worth double checking.

           

          Grant