Sunday, July 17, 2011

How to make a column to display the sum of all the other columns in OBIEE

In your 11th column, enter this:

Ifnull(Tablename.columnname1,0)+ifnull(tablename.columnname2,0)+....

You get the idea. The purpose of the if null function is that if any of the 10 columns have a null value it will still add the rest of the values in the other columns.

Until Next Post... :)

No comments:

Post a Comment