This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Calculate lookup values against a calculated column and then sum.
Example:
Lookup results * calculated_column
14,15,17 * 9
SUM((14 * 9)+(15 * 9)+(17 * 9))
How can I do this?
I verified the total should be 288 as you stated.
This is what I am getting.
9*32=272
{TOT HRS}*{LABOR-CST1}
and LABOR-CST1 comes from the function SUM({TECH-RATE})
