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!
1 Solution
Accepted Solutions
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
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
