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

Display a % below 1% in a performance tile

Received Response
41
Views
1
Comments
Jean-Francois Prevost
Jean-Francois Prevost Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Display a % below 1% in a performance tile

Content

Hi,

On Oracle BI for Oracle HCM

Could anyone tell me if the system displays results <1% as zero by default on a performance tile?

I am trying to calculate the % of women and when the result is below 1% (0.79%) then the display returns 0,0%

Any idea?

Thanks for your support

Best regards

Jean-François

Tagged:

Answers

  • Jackie Dunn
    Jackie Dunn Rank 2 - Community Beginner

    You have to cast it as a decimal - either create a calculation within the project or just reformat the number in the dataset to include 2 decimal places.