Thanks for your reply. This can be done, if I hard code the value, based on the Type 1 and Type 2 combination. But I need to refer to the other table (Table B) and pick the value from specific column based on Type 1 and Type 2. The reason behind this is the value in Table B can change over the period of time. So if value is picked dynamically, I dont have to worry about the change. If I hard-code it in expression without referring table B, then every time I need to change in the Expression
I hope I am able to convey my requirement.
Thanks & Regards
Perform a lookup on table B delivering attributes A, B, C, and D.
Then use the following expression term:
Decode( 2 * Type1 + Type2, 3, A, 4, B, 5, C, 6, D, NULL)
If Type1 = 1 or 2 and Type2 = 1 or 2, then "2 * Type1 + Type2" will yield one of the three values 3, 4, 5, or 6. The Decode() function will deliver either port A or port B or port C or port D or NULL.