Oracle Analytics Cloud and Server

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
44
Views
1
Comments

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.