Adding blank column in Oracel Answers OBIEE
973043Nov 7 2012 — edited Nov 9 2012Good 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