I have a table that is summed per week and i want to count the number of quantity per week NOT PER ENTRY/RECORD. What should be my formula?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
i need to find the available man hours by counting the total values per week then multiply it by 40

eg. A: count is 4 (4 weeks)

4*40 = 160

its like the entries are totaled per week but i will just count it as 1.

Photo of Ann


  • 22 Points

Posted 4 years ago

  • 0
  • 1
Photo of Eric


  • 40 Points
Typically records don't know about data on other records, and therefore they can't have calculations run on separate records. If that's not the case for your app, it might be easier to have someone from our Care team take a look at this with you. While logged in to QuickBase click Help -> Manage Support Cases. Once that page comes up, you can create a new case and one of our team members can look at this with you then.