Hi,
I have one table with project costs (many different elements with names and net costs) and second table with margin fee (i.e. 10%).
How can I combine to add another column to the first table and calculate margin using value from second table (10%).
Till now I used to add temporary column for both tables with value "&" and merge tables like "Left Outer".
It works but is there any easiest way to do it?
I have one table with project costs (many different elements with names and net costs) and second table with margin fee (i.e. 10%).
How can I combine to add another column to the first table and calculate margin using value from second table (10%).
Till now I used to add temporary column for both tables with value "&" and merge tables like "Left Outer".
It works but is there any easiest way to do it?
