Skip to main content
Solved

Add numbers in cell


Forum|alt.badge.img+3

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:

 @TheTimeSavingCo can you please help?

Best answer by BillH

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.

 

View original
This topic has been closed for replies.

2 replies

BillH
Forum|alt.badge.img+24
  • Brainy
  • Answer
  • May 9, 2024

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.

 


Forum|alt.badge.img+3
  • Author
  • New Participant
  • May 10, 2024

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.

 


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