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

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.