AM Best Online Help
The following options are available when creating a custom calculation from the Create Field Lists page. The selected database determines the Data Period available.
Fixed - The specific years selected in the calculation are the years used when creating reports. The calculation results do not change with the Data Period selected in Custom Reports.
Example:
( [FIELDNAME{2010}] - [FIELDNAME{2009}] ) / [FIELDNAME{2009}]
Using the example above, calculations will always use the 2010 and 2009 data regardless of the Data Period selected in Custom Reports.
The calculation results will be the same for all years.
Float - The Data Period selected in Custom Reports determines the data period used in the calculation. The calculation cannot span multiple years or quarters. The calculation uses data for one year only.
Example:
[FIELDNAME1{Float}] - [FIELDNAME2{Float}]
Using the example above, all calculations are updated to show the appropriate results based on the selected Data Period chosen in Custom Reports.
If 2010 is the Data Period selected, 2010 data is used.
If 2008 is the Data Period selected, 2008 data is used.
Referential - The data period specified in the calculation determines the years used when searching and creating reports. The calculation data period does not change with the Data Period selected in Custom Reports. Calculations are automatically updated when new data years become available.
Example:
( [FIELDNAME{Current Year}] - [FIELDNAME{Current Year - 1}] ) / [FIELDNAME{Current Year - 1}]
Using the example above, calculations will always use the Current Year and Current Year - 1 (Prior Year) data regardless of the year selected in Custom Reports.
The calculation results will be the same for all years.
If 2010 is the most recent data year, the Current Year is 2010 and Prior Year is 2009.
If 2011 is the most recent data year, the Current Year is 2011 and Prior Year is 2010.
Referential Float - The Data Period selected in Custom Reports determines the data period used in the calculation. Calculations are automatically updated when new data years become available.
Example:
( [FIELDNAME{Input Year}] - [FIELDNAME{Input Year - 1}] ) / [FIELDNAME{Input Year - 1}]
Using the example above, all calculations are updated to show the appropriate results based on the selected Data Period chosen in Custom Reports.
If 2010 is the Data Period selected, the Input Year is 2010 while the Input Year -1 is 2009.
If 2008 is the Data Period selected, the Input Year is 2008 while the Input Year - 1 is 2007.