This is an abbreviated view of my linker table with two tables that join to it.
LINKER TABLE
SALES|KEY
DEPARTMENT|KEY
CUSTOMER|KEY
PRODUCER|KEY
SALES1
SALES
ABC Corp.
(null)
(null)
SALES
ABC Corp.
PROD1
PRODUCER TABLE
PRODUCER|KEY
Percentage
PROD1
0.9
SALES TABLE
SALES|KEY
Commission
SALES1
10000
With the structure above is it possible to write an expression that takes the "Percentage" multiplied by the "Commission" based on the Department|Key and the Custiomer|Key being the same....even though there are nulls in the Producer|Key and Sales|Key? Or is it impossible to correlate the values because there is no true relationship between the Producer table and the Sales table?
The expression "Percentage*Commission" would work. However, from the data in the above link table, there are nulls in the records for SALES|KEY and PRODUCER|KEY, so it will return nulls.
