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

function absolute in calculated item

3689512

Im trying to calculated the percentage difference between two columns using a calculated item ($2-$1)/$2 but it fails when both values are less than 0. Is there a way to apply absolute function? Documentation says yes but havent managed to make it work

Find more posts tagged with

Accepted answers

All comments

SriniVEERAVALLI

Try like below

( ($2-$1)*1.00)/$2

Gianni Ceresa

3689512 wrote:... but it fails when both values are less than 0.

Can you define "fails" ?

Do you have an error? Do you have a wrong result? What kind of result? (post an example or screenshot maybe?)

3689512

didnt work gives the same result

[Deleted User]

Yeah because that's not how "absolute" works mathematically... "times 1.00" is a trick to prevent integer divisions and has nothing to do with absolute numbers.

3689512

the sign is wrong when both numbers are negative . E.g: -2-(-4)/-4. where -2>-4 so it's 50% higher not -50%

3689512

the sign is wrong when both numbers are negative . E.g: -2-(-4)/-4. where -2>-4 so it's 50% higher not -50%

[Deleted User]

Is there a specific reason why you use $ notation and not a real formula where you can use ABS?

3689512

what do you mean with @ notation? It's a calculated item not column. is there another way to do math operations in a calculated item?

[Deleted User]

I know it's a calc item. My point is: actual formulas are far more precise and with calc items it's easy to have something in $1 and $2 which isn't what you expect (influenced by prompts, filters, selections,........)

3689512

I dont know how to get the result i want using calculated column. My data is like this.

Where % Var is the calculated item. How can i create a new column with just the percentage difference between column Real and Plan