Forum Stats

  • 3,874,219 Users
  • 2,266,685 Discussions
  • 7,911,771 Comments

Discussions

How to add two columns in criteria(OBIEE 11g)

Hi,

I am trying to add two columns in a criteria in obiee

*"Fact - OLB Processed Invoices"."Invoice Amount - Functional Currency"__"Fact - OLB Processed Invoices"."AR Tax Amount - Invoice Currency"

but the problem is :-
The first column have 500000000 and the second column contains NULL values the actual table. I think this might be the problem when I am trying to add them it is giving no output.
just a blank box.

Can any one tell me how can we add columns in this condition.

Thank to one and all.

Best Answer

  • SriniVEERAVALLI
    SriniVEERAVALLI Member Posts: 8,539 Gold Crown
    edited Mar 20, 2013 11:03AM Answer ✓
    Try IFNULL(expr, value)
    for other column

    "Fact - OLB Processed Invoices"."Invoice Amount - Functional Currency"+IFNULL("Fact - OLB Processed Invoices"."AR Tax Amount - Invoice Currency",0)

    Edited by: Srini VEERAVALLI on Mar 20, 2013 10:02 AM

Answers

This discussion has been closed.