Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Set number of visible decimals of a measure via a calculation

Needs Votes
23
Views
3
Comments
Alin-Oracle
Alin-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Hi everyone,

I'm currently building a report that has a varied audience from top level management to first line manager. The numbers we show range from a few k$ to m$. All our reporting is built to be as consistant as possible so for example, In a report we should only k$ or m$ so there is no missunderstanding on how the number is being shown. We use single decimals for m$ and no decimals for k$ Therefore, this is a reason why abbreviations wouldn't help.

What could greatly help is to have the ability to control the number of decimals via a calculation. I have noticed that while the measure decimal setting is set to auto and using cast(measure as int) in the calculation, the measure is shown by default with no decimals. But we lack the control for adding or removing decimals further.

Happy to know your thoughts !

Tagged:
3
Up
3 votes

Needs Votes · Last Updated

Comments

  • Luis E. Rivas -Oracle
    Luis E. Rivas -Oracle Mod

    Hi Alin - Are you formatting your measures to currency? There is a bit more control for decimals for currency, but maybe I'm not fully understanding the issue. Here are the controls for currency:

    image.png
  • Alin-Oracle
    Alin-Oracle Rank 1 - Community Starter
    edited Jan 27, 2025 7:55AM

    Hi Luis !

    What we're trying to achieve is to give users the freedom to chose wether they want to see the numbers in k$ or m$ via a parameter. The ideal view would look something like this where the 2 measures here are actually a single one and users select via the parameter which one they want to see based on their needs.

    image.png
  • Luis E. Rivas -Oracle
    Luis E. Rivas -Oracle Mod

    Thanks for the clarification Alin - I don't think this is doable. This idea has been set to Needs Votes, which will help prioritize any future enhancements in this area.