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 3 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 3 years ago

  • 1
  • 2
No problem.

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