Discover what data silos are costing your org in our commissioned Forrester study. Learn more
Mar 09, 2020 08:38 AM
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?
Mar 09, 2020 04:34 PM
It is a bit hard to tell what you want without names of fields, but I’m guessing that you have three lookup values and want to multiply them times a value in a fourth field, and store the final product in a fifth field.
You can add without using the SUM
. Also use parenthesis to control the order of operations.
({lookup1} + {lookup2} + {lookup3}) * 9
If this isn’t what you want, try looking at the formula field reference.
Mar 10, 2020 03:51 AM
Hi Airtable,I want it to take the lookup field values and multiply by a field.
array =14,15,25
14*field
15*field
25*field
Then sum results of this.
Mar 10, 2020 09:14 AM
Is the array in a rollup or lookup?
If the array is in a lookup, create a rollup instead.
Then try this formula in the rollup:
SUM(values) * {field}
Although this formula calculates the sum first, you get the same result according to the distributive property.
(14 * field) + (15 * field) + (25 * field) = (14 + 15 + 25) * field
Mar 11, 2020 09:49 AM
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})
Mar 11, 2020 05:42 PM
9 * 32 most certainly isn’t 272.
Can you check how many decimal points you are displaying for {TOT HRS}, {LABOR-CST1}, and any other fields feeding into the calculations? It could be that the formula for either one is rounding the number to the nearest integer for display purposes, but using a different number in the actual calculations.
Mar 13, 2020 01:58 PM
I still haven’t been able to resolve this issue.
Mar 14, 2020 09:10 PM
I’m sorry that you are still having trouble with this issue.
It is difficult for us to help without more information.
Mar 14, 2020 11:00 PM
To echo @kuovonne, there needs to be a lot more detail in your description of the problem in order for us to provide meaningful assistance. Please describe in great detail:
It’s generally better to provide too much information than not enough.