Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
blank column
TKQ5Q
Rank 3 - Community Apprentice
Hi everyone
I am using Oracle Business Intelligence Enterprise Edition 11.1.1.7, how do I add a blank column to the analysis.
or how do I add up the 3 columns which contain formula of sum
Thank you.
Tagged:
0
Answers
-
Blank column: Edit Formula and then type in null.
Your second question I don't understand. What do you mean by that?
0 -
Hi Sir,
For 2nd question, is that I have 3 column (called A,B,C) and each of these column has formula "SUM(case when "column" = 'ABC' then 1 else 0 end)"
How do I add the total for the 3 columns,A,B,C?
Thank you.
0 -
"Table"."Column1" + "Table"."Column2" + "Table"."Column3"
0