1 Reply Latest reply on Apr 13, 2012 10:46 AM by philmodjunk

    Display Negative Number as Zero

    ZoocMan85

      Title

      Display Negative Number as Zero

      Post

      Is there an easy way to display a calculation result that ends in a -negative to just display zero ?  

        • 1. Re: Display Negative Number as Zero
          philmodjunk

          There is no data format you can specify that will display 0 in place of a negative.

          A calculation field could, however, make such a substitution and then you can put it on your layout in place of the actual data field:

          If ( Field < 0 ; 0 ; field )

          or

          Max ( field ; 0 )

          Or I suppose you could place a 0 as layout text on top of the field and use conditional formatting to hide the 0 when the value is 0 or larger and to hide the data in the field when the value is less than 0...