Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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.
  • No labels