Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 03, 2018 07:55 PM
So I was able to write out a simple formula in a table to see what percentage of the people in that row participated out of the total number of people in the table, but I had to manually enter the total number of people - the formula looks like this - ({# of Participants}/433)*100
It works, but the issue is that every time we have more participants, I’ll need to update the 433 number. How can I get this to update automatically every time a new person is added to the total?
Thanks!
Mar 03, 2018 08:15 PM
I guess it depends on where that 433
comes from. :winking_face:
Is that the number of records in the table, or is that a population number also included in the record (that is, does the record have a {# of Participants}
field and a {Total People}
field)? (If the former, I have to wonder a bit about your data model, since if each record = 1 person, {# of participants}
should only equal either 0
or 1
.)
If this is the same base as mentioned in your other post, I’ll take a look at this issue once you can provide a shared link to the base. If it’s a different base, I’ll need a link to it, as well.
Thanks!
Mar 03, 2018 08:18 PM
That is where the number is coming from, from the sum at the bottom. There isn’t a {total people} field because this is counting from another table. Are the screenshots enough to help?
Jul 25, 2018 12:18 PM
I have the same question. So bumping for response.
Aug 04, 2018 12:51 AM
The easiest way to accomplish this is to use the old trick of linking every record in the table to a single record in another table — called, let’s say, [Calc]
. In that single [Calc]
record, define a rollup field that rolls up {# of Participants}
with an aggregation function of SUM(values)
. Pull that value back to the main table using a lookup or rollup field.
Oct 10, 2018 09:02 AM
I’m trying to perform what should be a pretty simple operation, but I can’t quite get it to work in Airtable. I have a column of donations and I’d like to display, somewhere, the sum of these donations as percentage of a set goal. In Excel, I’d have something like =SUM (A2:A10)/100, but I’m not seeing how I can do that in a cell or in a block.
TIA!
Oct 10, 2018 09:21 AM
I think you need this:
Oct 11, 2018 01:57 PM
Thank you - this was just the walk through I needed.
May 17, 2023 04:02 PM
Yes, does seem to be a simple question, but I'm not seeing what I'd think would be right for my case, either:
For my issue, I have #invited, #who showed up, and calculation of %showed up. Simple math but apparently, not the case LOL.
Jul 29, 2023 06:50 AM
I also want to calculate a percentage of a record count, on an interface page. All I want is the percentage of converted clients from a total list of leads. It should be really simple, but can't see any simple answer here.