Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Decimal Places - Numeric Format

Received Response
1
Views
1
Comments
User_97XVQ
User_97XVQ Rank 3 - Community Apprentice
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

Hi,

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?

Thanks

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.