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

OBIEE Dashboard Gauge not displaying decimals for custom formulas. Any work-around?

image237

I have made a custom formula that calculate SPI(t) (an Earned Schedule metric) values. I selected the Dial Gauge to display it in OBIEE. But the dial gauge only displays in whole numbers. But the same gauge is able to display decimals when it is displaying values of default SPI. I Have tried adjusting the settings without any success. Is there a solution to this?

Find more posts tagged with

Accepted answers

All comments

RVohra

I cannot recall, please check if there is an option to change the Data Type to Double.

Chere-Oracle

Hi image237,

Do other views display decimal for SPI(t), such as table or pivot table veiws? If not, what formula are you using for SPI(t)?

Wayne Van Sluys

What does your formula look like?

Wayne Van Sluys

try multiplying by 1.0

Chere-Oracle

If all parts of your formula are Integers, you will get an Integer value. To fix in this case, multiply the left-most value by 1.0 — this will ensure the whole formula. If you put the 1.0 multiplier at the end, it may not work as intended.