Introduction

Report calculation prefixes group and categorize similar calculations. This allows them to appear next to each other in sorted data set lists. These calculations are likely to share the same prerequisite calculations, and similar rules for aggregating, averaging and rounding. 

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 or FTD
  • "Life to date"
  • Returned values will be calculated from the earliest transaction to the period’s end date to the period’s end date.