1 Reply Latest reply: Sep 29, 2015 11:52 PM by MelaSarenas _ RSS

    I need to show negative values instead of nulls on part of my table?

    Doug Nichols

      How do you show the negative amount on a table instead of showing nulls.  I need the negative value to show?

        • Re: I need to show negative values instead of nulls on part of my table?
          MelaSarenas _

          Hi Doug,

           

          Both DPS and Monarch Classic are able to identify negative numeric values and display it with '-' before the number.  The reason why (null) appears on numeric fields is that Monarch could not translate the values correctly.

           

          This leads me to ask how does your data look like.  Maybe we need to define a calculated fields that would correctly transform your negative amounts.  The calculated field would depend on how your data looks like.

           

          Regards,

          Mela