Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

blank column

Received Response
661
Views
3
Comments
TKQ5Q
TKQ5Q Rank 3 - Community Apprentice
edited Aug 13, 2024 5:12PM in Oracle Analytics Forum

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:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Blank column: Edit Formula and then type in null.


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

  • TKQ5Q
    TKQ5Q Rank 3 - Community Apprentice

    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]
    [Deleted User] Rank 2 - Community Beginner

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