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
2010-02-21 20:38:28