Multiply two columns from two separate tables

[mclarkson]

Hi All,

I have a projects table "Workpackage" that I am trying to create a priority score for and weighted score "Weighting table.

Can anyone tell me how I can do this?

Many thanks

Mike

[TeeSee1]

You can get values from another table based on the value of a column by using LOOKUP()

Get column value from row in table or slice

In you case use two LOOKUPs to retrieve weight values to calculate the score.

[Sirfyaad]

Below I have given an example. 

[Your COLUMNS] * LOOKUP([YOUR LOOKUP COLUMNS], "TABLE NAME", "SEC TABLE LOOKUP COLUMN", "MULTIPLE VALUE COLUMN")