Help

Add numbers in cell

Solved
Jump to Solution
117 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!