Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Thanks for the quick response. Is there any other way, I can calculate Variance and Variance % to get the desired data formats?

in Custom data formats for 2 calculated columns in OBIEE Reports Comment by User_YU3AO Oct 27, 2017 5:42PM
I would like to keep Variance in number format, and Variance % in percentage format.

in Custom data formats for 2 calculated columns in OBIEE Reports Comment by User_YU3AO Oct 27, 2017 5:22PM
Hi, I have attached the existing table available in database (just Actual and Plan data), and calculated columns using selection steps (highlighted in yellow).

in Custom data formats for 2 calculated columns in OBIEE Reports Comment by User_YU3AO Oct 27, 2017 5:20PM