Ad Hoc Calculations

Ad hoc calculations require more system resources. Each time that the system processes ADB calculations, it extracts data for all the days within the period type from the ADB ledger. Therefore, you usually want the system to use the incremental calculation method for regularly scheduled averages (MTD, YTD, and QTD). Otherwise, you can use the ad hoc method.

The ad hoc calculation for average balance is the same as the incremental calculation:

Average Balance = Aggregate / number of days with in the requested period type

The difference is that the ad hoc method does not use prior period balances. Instead, it requires all the daily balances needed to calculate the requested period type. (The incremental process requires only the daily balances from the previous period.)

This table shows how the system calculates average daily balances for a date-to-date period type (DTD), starting January 5 through the request date of February 1. The ADB ledger uses a monthly calendar.

Calculation Using a DTD Period Type

This table shows incremental day-to-day calculations:

Incremental Day-to-Day ADB Calculations

In this case, even though February 1 is in the next period, the system still uses the previous day's ending balance and aggregate amount in the calculation.

In the sections that follow, there are examples of how these period types are used in calculations.