AX2474
Axiom.Calculations
The Axiom.Calculations system table contains information about the defined calculation types in your system.
NOTE: This table returns the calculation types that are available to be used within calculated fields. If you want to return the actual calculated fields defined for your tables, such as CYATOT, query the Axiom.CalculatedFields table.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
CalculationName |
The name of the calculation. This is the name that displays in the Calculation Type list when you are creating a calculated field. |
|
TimeType |
The time type considered for the calculation, either FullSequence or Quarter. |
|
IsTiedToCurrent |
Whether the calculation is tied to the current period (True/False). |
|
IsTiedToAlternate |
Whether the calculation is tied to an alternate current period, as defined for the calculation (True/False). |
|
AlternateCurrent |
The alternate current period used for the calculation (if applicable). |
|
DefaultAggregationType |
The default aggregation type used for the calculation: Summation, Average, LastInSet, WeightedAverage, or Subtraction. |
|
SupportsAlternateAggregation |
Whether the calculation supports alternate aggregation types in addition to the default aggregation type (True/False). The remaining columns only apply if this is True. |
|
ConditionForSummation |
A filter criteria statement that specifies the records for the summation aggregation. |
|
ConditionForAverage |
A filter criteria statement that specifies the records for the average aggregation. |
|
ConditionForWeightedAverage |
A filter criteria statement that specifies the records for the weighted average aggregation. |
|
ConditionForLastInSet |
A filter criteria statement that specifies the records for the last in set aggregation. |
|
ConditionForSubtraction |
A filter criteria statement that specifies the records for the subtraction aggregation. |
Save Type 4 support
Axiom.Calculations can be modified using Save Type 4. See Managing calculation types using Save Type 4.
