blank column

TKQ5Q

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.

[Deleted User]

Blank column: Edit Formula and then type in null.

Your second question I don't understand. What do you mean by that?

TKQ5Q

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.

[Deleted User]

"Table"."Column1" + "Table"."Column2" + "Table"."Column3"