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.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Calculate rollup values against another field

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

0
1299
8

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?

8 Replies 8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Mar 13, 2020 01:58 PM

I still haven’t been able to resolve this issue.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Mar 14, 2020 09:10 PM

It is difficult for us to help without more information.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:

- What tables are involved in this setup
- What fields are involved, including types and sample data
- The specific formulas in any formula fields, and examples of the data being generated by them

It’s generally better to provide too much information than not enough.