tags:

views:

256

answers:

1

I have 2 lists with some common cols and Need to multiply the Calculated Sum value(of certain col) of one list to the particular col value in other list .

+2  A: 

The formula in a calculated site column can reference only other site columns that are in the same list or library. Therefore, when you add the calculated site column to a list or library, you must also add the site column that is referenced in the formula.

If I were you, I'd add a column where I LOOKUP the value from the List A, and then use that column for my calculated field in List B.

Lina Al Dana