2 Replies Latest reply on Aug 29, 2016 8:43 AM by Wij

    Measure

    Wij

      Hi,

      In my database, i have a column that contains numbers and the datatype is Float (example: 30.65- 24.25- 14.1- ...).

      I want to use this database in Oracle BI, and considered this column as Measure, and Agregation rule: SUM. The measure's datatype become: DOUBLE.

      When I go to http://toshiba-pc:7001/analytics/  I found that numbers are different and are not Float .. (example: 65- 31- 193- 1- ...)

       

      Thanks.

        • 1. Re: Measure
          Gianni Ceresa

          Hi,

          Did you check the properties of the column to set the number of "decimal places" to something else than 0 ?

          Because by default all the measures are displayed as numbers without decimal places.

          Not seeing the decimal part doesn't mean it isn't there

           

          PS: it's in your analysis, column properties > data format > check "override default data format" and set the number of decimal places you want to see.

          1 person found this helpful
          • 2. Re: Measure
            Wij

            You're right, Thank you very much It's resolved.