Using summary totals in another report

JoeBlouin
Qrew Member
3 years ago
Tracking attendance in 'Attendance' table. (child of 'Associates' table)
different types of absences cost different amount of "points"
1/2 NF = .5
1 NF=1
NCNS = 3.5

I built a summary table that totals the different types of absences and gets me a total points per Associate.

My challenge is that Each Associate started with a different Allowable NF amount... For instance Associate A is allowed 7 and Associate B is allowed 5.
The number allowed per Associate is stored in the parent table 'Associates' per each Associate.
I would like the calculate the remaining points...
If Associate A started with 7 allowed but has accumulated 4 points in absences, then the remaining would be 3 points.

------------------------------
Joe Blouin
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  One Associate has many Attendance
  On the relationship, simply make a summary field to summarize the points.
  
  Alternatively, make three summary fields to count the # of:
  1/2 NF
  
  Then duplicate that for the other two absence types
  
  No doubt you will also need a time period filter on that. Be sure to have the filter be "relative", ie don't lock it in for the year 2022, but make it for "the current Year", or the Previous 1 year. You don't want to have to adjust the summary field properties each year.
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - JoeBlouin
    Qrew Member
    3 years ago
    Perfect. Worked like a charm. that opens up so many other options for me also. Thanks so much Mark!
    
    ------------------------------
    Joe Blouin
    ------------------------------

Forum Discussion

Using summary totals in another report