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