Analytics Report - Planned Revenue Shipments This Month

Total revenue for all jobs that have been completed in the current month

Description:

Sum of Job.Revenue for Jobs where:

  • Job.Scheduled=true
  • Job.ScheduledFinishDate is in the current month

Calculation:

SUM(Jobs.Revenue) WHERE Jobs.Finished = 'TRUE' AND Jobs.NeedDateTime IN MONTH(now())
Found in Reports:
  • Sales
  • Planning
  • Operations
  • Finance