Current Position:Home > Adding blank column in Oracel Answers OBIEE

Adding blank column in Oracel Answers OBIEE

Update:10-11Source: network consolidation
Advertisement
Good morning.
I am attempting to add a 3 blank columns in OBIEE and then adding a formula to one of the blank columns to do a simple math calculation between 3 other columns. I used "CAST(Null as double)" in my column formula to make it a blank column and not pulll data from the field column that I added.
This is what I have so far:
Column1 formula = "Cast (Null as double)"
Column2 formula = "Cast (Null as double)"
Column3 formula = "Cast (Null as double)"
Column4 formula = data already included from the column that I added.
This is what i'm trying to do:
Column3 = (Column4 - Column1 + Column2) <----- In excel I would do something like "=D4-E4+F4" (example)
When I do my SUM function in OBIEE and try to add the columns, it pulls in "Cast(Null as double)" and not the actual column name that I custom edited.
Any help would be appreciate on how to add a blank column and add a simple calculation formula to calculate data from the blank columns once I export my report to excel.
Thank you,
Edited by: 970040 on Nov 7, 2012 8:24 AM

The Best Answer

Advertisement
Thats correct. When I export the report I want to see blank values in the columns. so when I enter data into those blank fields on my excel spreadsheet, I want the totals column to calculate according to my formula specified. My issue is when I specify a null value in my columns in OBIEE, im unable to put a formula to calculate the values in my other columns.
This is what I have so far in OBIEE:
Column1 formula = "Cast (Null as double)"
Column2 formula = "Cast (Null as double)"
Column3 formula = "Cast (Null as double)"
Column4 formula = data already included from the column that I added with values.
This is what I’m trying to do:
Column3 = (Column4 - Column1 + Column2) <----- In excel I would do something like "=D4-E4+F4" (example)
How can I add a value to my column so that when I export it to excel, the column fields will have the formula already included such as "=D4-E4+F4" and also each row formula corresponding to the correct Row Number.