how to lookup values for calculated fields

Aug 11, 2009 at 5:45 PM
Edited Aug 11, 2009 at 6:03 PM

Hi, how can I solve the following situation.

list  1
·         title
·         value A

list 2
·         title
·         value B (lookup to list1 showing the title)
·         value C
·         value D (calculated = value A * value C)

There is a "list 1" with a column "value A" and a "list 2" with a column "value B" who refers to "list 1" with a kind of lookup. In the "list 2" is another column "value D" configured as a calculated field, which is a result of the calculation of “value C” multiplied by the related “value A” of the lookup.

How can I get the “value A” of “list 1” for calculation reasons in “list 2”? Are there some known webparts, who solve this problem?

Aug 11, 2009 at 6:44 PM

Hi fluehlera,

It looks like your talking about a specific project on CodePlex. This is the discussions for the site itself. You may have much better luck posting it on that project's discussions.