Comparison Date Formula Field, Column Layout Table

Here you can enter a formula that will tell the program which period should be used to calculate the amount in this column. You can use this if you want to include figures from various periods on the same report.

The formula calculates the comparison period in relation to the period represented by the date filter on the report request. The formula can contain a maximum of 10 characters, consisting of numbers and letters that the program recognizes as abbreviations for time specifications.

For example:

-1Y	Same period 1 year earlier

Important

If you put a checkmark in The Keep Comparison Period Scope field, the program calculates the amount in this column and keeps the period type scope even if the period type selected is different.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table	Location
Column Layout Table	General Ledger
Column Layout Table	General Ledger