1 Reply Latest reply on Mar 4, 2016 2:43 PM by Christian Berg

    Decimal Places - Numeric Format




      I have a report in OBI that uses direct database request to return results, there is a numeric field I am extracting from a table.


      The format in the table is a decimal number and for example appears as 1.6900 but appears as 16900 in OBI. I have used Cast function as double precision but that has no effect


      There should be a decimal point added before the last four numbers


      For example


      7890999 = 789.0999

      1560000 = 156.0000

      450000 = 45.0000

      10987 = 1.0987


      Can anyone suggest if there is a numeric format that can used to convert the decimal format as above?



        • 1. Re: Decimal Places - Numeric Format
          Christian Berg

          Seems weird that the returned result isn't the actual number.  Are you sure you're using the correct data types? Is the data stored in the database really 156.0000, so "one hundred fixty-six and zero cents"?


          Also: since you're doing a direct database requests it's all in the code and not necessarily in how OBI handles numbers.