
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2020 12:03 PM
How do I write a formula to add total based on the colour of field/column towards the left? e.g in this table I want to add all payments labelled cash and sum in field 7.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2020 01:02 PM
You can’t sum them in Field 7, but you can group your records by Type, and then use the summary bar to view the Sum.
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 11, 2020 01:16 PM
Welcome to the community, @yousaf_saleem! :grinning_face_with_big_eyes: One possible way to rethink your setup is to convert your {Type}
field into a link to another table. On that table, you can roll up and sum all values for each type. Will that work?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2020 07:48 AM
if I want to sum total for only a certain date how I will do that?
