Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

BIP Number Format

41
Views
2
Comments
Prudence K
Prudence K Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

Content

Hi all - I have a BIP report we use for absences.  An employee can have absence duration, for example, of 1 or .015 (depending on how they are taking their time). 

If I have the report display those columns in text, it will display 1 and .015 fine, but then I have to convert to number on export. 

If I have it display as a number, it will display based on the number of decimals I choose.  I do not want the report to display duration of 1.000 in order to get the .015 displaying properly as a number.

The report was built by building the data model and then clicking on "Create Report" to build the report with the Report Editor.  We did not upload/use any templates.

Are there any suggestions for this?  Thank you in advance!

Tagged:

Comments

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Just to understand correctly: You want "0.015" - hence the string as it seems to be stored this way - to be displayed as 0.015 - the number, but "1" - again the string - to be displayed as 1 rather than 1.000 - the number?

  • Prudence K
    Prudence K Rank 5 - Community Champion

    Hi Christian,

    I did a little digging and it appears we are using the field DURATION from the ANC_PER_ABS_ENTRIES table.  It appears it is set as a number field.

    What you have is correct:
    YES - 1 and .015
    NO - 1.000 and .015
    NO - 1 and 0 (this would be the rounding of the .015)

    I need to add these together to find total duration someone is out of the office.

    Thank you!