Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.