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

    Display Negative Number as Zero



      Display Negative Number as Zero


      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

          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 )


          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...