2 Replies Latest reply on Feb 19, 2016 12:00 AM by tays01s

    Rounding

    tays01s

      Can you apply a more sophisticated 'rounding' than provided in Inspector? ie. A number <100 I'd want to 1 decimal point, but >100 I'd want rounded to 0 decimal points. A very small number might need 2 decimal points.

        • 1. Re: Rounding
          fitch

          Not sure how you define 'very small' but here's one way to do it:

           

          Case(

          n > 100 ; Round( n ; 0 ) ;

          n > 1 ; Round( n ; 1 ) ;

          Round( n ; 2 )

          )

           

          But this has to be implemented at the data level, it can't be done at the layout level via Inspector's formatting options.

          • 2. Re: Rounding
            tays01s

            I was actually wondering if there was some trick within 'formatting', but yes, your method will work through an autoenter field when I import the data. Thanks.