Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Add numbers in cell

Solved
Jump to Solution
983 2
cancel
Showing results for 
Search instead for 
Did you mean: 
vibhudawar
5 - Automation Enthusiast
5 - Automation Enthusiast

How can I add all the values inside a particular cell in the Revenue AVIDZ (in Amount) and then present as "Total Revenue" hence stating revenue for a particular client?

Revenue field is a lookup field.

Here is the screenshot of the table:

Values and Total Revenue ColumnValues and Total Revenue Column

 @TheTimeSavingCo can you please help?

1 Solution

Accepted Solutions
BillH
9 - Sun
9 - Sun

It looks like your "Revenue AVIDZ" column is a Lookup to a linked table.  If I'm seeing correctly you should be able to switch "Total Revenue" to be a Rollup to the same field and set it to sum.  Your names will be different than this example, but hopefully it will help.

BillH_0-1715281377221.png

 

See Solution in Thread

2 Replies 2
BillH
9 - Sun
9 - Sun

It looks like your "Revenue AVIDZ" column is a Lookup to a linked table.  If I'm seeing correctly you should be able to switch "Total Revenue" to be a Rollup to the same field and set it to sum.  Your names will be different than this example, but hopefully it will help.

BillH_0-1715281377221.png

 

vibhudawar
5 - Automation Enthusiast
5 - Automation Enthusiast

I have now strong faith on Airtable community just because of people like you!
Thanks a lot man. Much appreciated!