nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Set number of visible decimals of a measure via a calculation

Alin-Oracle

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 !

Find more posts tagged with

Report

Reporting

Analysis and Data Visualization

Prompts

Report Delivery

Needs Votes

Status: Needs Votes

Comments

Luis E. Rivas -Oracle

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:

Alin-Oracle

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.

Luis E. Rivas -Oracle

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.