Skip to main content
Solved

Counting Data based on Parameters

  • February 15, 2024
  • 1 reply
  • 9 views

Forum|alt.badge.img+4

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!

Best answer by TheTimeSavingCo

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

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

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