Hello,
I'm having a problem getting the proper value from my calculated field in my table.
Does anyone see the problem here?
my calculated field is:
StdCost = ([R1]*[R1Percentage])+([R2]*[R2Percentage])+([R3]*[R3Percentage])
R1, R2, and R3 are all lookup fields that look to another table and each is the same, 2 columns, 1st Column is a description of the R# (column 0) and 2nd column is Cost (column 1)
In my data for this example:
R1 = 2.98 R1Percentage = 60%
R1 = 4.11 R2Percentage = 25%
R1 = 7.25 R3Percentage = 15%
My std cost based on the above calculation is returning 1.55
Yet if I add 3 more fields to the table as follows:
R1Cost
R2Cost
R3Cost
and manually type in the correct cost for each R# into R1Cost, R2Cost, and R3Cost fields by referencing what I see in the 2nd column of the dropdowns of R1, R2, and R3,
my formula (calculated field) syntax is correct which returns a correct value of 3.903
Why are my lookup fields not using the number I see from column 2 in their respective dropdowns?
Thanks for any suggestions,
BJF
I'm having a problem getting the proper value from my calculated field in my table.
Does anyone see the problem here?
my calculated field is:
StdCost = ([R1]*[R1Percentage])+([R2]*[R2Percentage])+([R3]*[R3Percentage])
R1, R2, and R3 are all lookup fields that look to another table and each is the same, 2 columns, 1st Column is a description of the R# (column 0) and 2nd column is Cost (column 1)
In my data for this example:
R1 = 2.98 R1Percentage = 60%
R1 = 4.11 R2Percentage = 25%
R1 = 7.25 R3Percentage = 15%
My std cost based on the above calculation is returning 1.55
Yet if I add 3 more fields to the table as follows:
R1Cost
R2Cost
R3Cost
and manually type in the correct cost for each R# into R1Cost, R2Cost, and R3Cost fields by referencing what I see in the 2nd column of the dropdowns of R1, R2, and R3,
my formula (calculated field) syntax is correct which returns a correct value of 3.903
Why are my lookup fields not using the number I see from column 2 in their respective dropdowns?
Thanks for any suggestions,
BJF