AX2056
This section discusses requirements and considerations for using calc methods with Axiom queries. Calc methods define the formatting and calculations for records being inserted into the Axiom query's data ranges.
You can use calc methods from the sheet's calc method library, or you can use an in-sheet calc method.
-
Calc method libraries are stored per sheet name across a file group, and can only be used in templates/plan files. When using calc method libraries, each record to be inserted can be assigned a different calc method.
-
In-sheet calc methods are defined on the target sheet of the Axiom query, in the designated rows or columns as specified on the Control Sheet. In-sheet calc methods can be used in any Axiom file, but are always used in report files. Each Axiom query can have only one in-sheet calc method, so every record inserted uses the same calc method.
Calc methods apply when the Axiom query's rebuild behavior is set to either rebuild or insert. If an Axiom query is update-only, then calc methods are not applied to the data.
AX2056
