- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2024 07:30 AM
I have two tables: "Billing" and "Activities". I'm trying to find a way to combine this data so that I can see $ received from bills while only including "TimeEntry's". In this specific scenario, the amount I would need to see is $530, since the $100 is an ExpenseEntry.
It is way too time consuming to manually count the hundreds of records, so I need a formula or an easier way to compute this. Thank you very much!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2024 07:59 AM
You could link them up and use a rollup field like so:
The rollup field is set to only include records where the "Name" value is "TimeEntry", and here's the base for your reference
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 15, 2024 07:59 AM
You could link them up and use a rollup field like so:
The rollup field is set to only include records where the "Name" value is "TimeEntry", and here's the base for your reference
