In a summary report, I need to summarize two weeks of Data. The choices I have are by Week/Month. I need Biweekly.

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
For payroll reporting, I need to summarize data for a two week time period.  Each "entry" has a Starting Date (and aggregates Daily Time Card data from child table). 

Is there any way to Summarize Bi Weekly using the crosstabs feature, see image
Photo of molsonite

molsonite, Champion

  • 10 Points

Posted 2 years ago

  • 1
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
No problem.

Make a field called First Day of Pay Period with the following formula

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=43&rl=yp