4 Replies Latest reply on Jan 19, 2012 8:14 PM by deepamathur0

    Problems using multiple data sources

      Hi,

       

      I have 2 data sources connected to tables in different Oracle databases.

      I have setup a relationship using a common field in these tables.

      I need to display measures from both sources in a tabular report, such that I need to calculate difference between a column from source A and Source B. Since Tableau automatically does an outer join, it displays Null for the measue from Source B if it is there in A and not in B, which is fine. But, the Difference also does not get calculated. It should just display the value of source A if there is no value in source B.

      How do I resolve this? I already tried all logical functions like ISNULL, IFNULL in my difference formula.

      I am also attaching a screenshot of the report.

       

      Thanks,

      Deepa