Description

The report field suffixes indicate the range of data included in a specific calculation field. Not all fields will have all possible suffixes as there nature would make them redundant. If a calculation does not have a suffix it is a typical indication is calculation is not bound to period or report dates.

Calculation Prefixes

Period Suffixes

• PD
  • "Period to Date"
  • Returned values will be calculated from the period’s start date to the period’s end date.
• PD2
  • "Period 2, to Date"
  • Some reports can be executed for two periods. PD2 calculations will be calulated from the second period's start date to it's end date. 
• PrPD
  • "Prior Period"
  • Returned values will be calculated from the prior period’s start date to the prior period’s end date.
• 4wk
  • "Last 28 days"
  • Returned values will be calculated from the date 28 day prior to the period’s end date to the period’s end date.
• LTD
  • "Life to date"
  • Returned values will be calculated from the earliest transaction to the period’s end date to the period’s end date.