Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Subtracting Columns (2columns in one measure)

865258May 29 2011 — edited Jun 1 2011

Hi pros,

I am new to OBIEE and still exploring the functionalities. However; I find it difficult in making a way to subtract the values from two columns. For example,I will subtract the values under the column1(year 2009) and column2(year2010) and put the each of the result in the third column. I tried using $1-$2 but later found out that the values of $1 and $2 are different with the values of each columns.

Also is there a way that it would be dynamic based on the dashboard prompts? Because I will not only use 2009 and 2010 as years.

Also what is the meaning of "$"?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2011

Added on May 29 2011

#bi, #business-intelligence-applications, #obiee, #oracle

2 comments

695 views