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.
Blank column: Edit Formula and then type in null.
Your second question I don't understand. What do you mean by that?
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?
"Table"."Column1" + "Table"."Column2" + "Table"."Column3"