Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Cannot handle Null cells in calculated columns from layout editor in BIP
We are creating a report using two data set - one is SQL based and another is loaded from excel. Using layout editor we are trying to create a calculated column subtracting where col2 is from excel data set and col1 from sql data set, where in a cell in col2 the value is null and there is corresponding value in col1 but in the calculated col 3 the value is NULL this is wrong example below
col1 - col2 = col3
100 - NULL = NULL. This is wrong it should be 100.
150 - 50 = 100 - this is coming correctly
Answers
-
Can you please try replacing NULL with 0 in the calculation. something like:
COL3 = (IFNULL(COL1, 0) - IFNULL(COL2, 0))
Hope this help.
Cheers,
0 -
I cannot use functions when I am defining calculated field from a layout editor, refer to attached doc
0 -
Hi,
In that case, please handle the NULL conversion in the Data Model it self.
0
