Oracle Business Intelligence 12c (OBIEE)

https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/manipulate-members-groups-and-calculated-items.html#GUID-58EF86B8-B… Maybe im mixing subjects.

It's an external db source related to Essbase. These are my columns. Location contains "Plan" and "Real". I want to obtain the percentage difference between Plan and Real from the same month.

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

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?

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

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

didnt work gives the same result