Functions¶
Autory uses Excel's functions and function syntax as its baseline, and adds many custom functions on top of that. This section describes those custom functions.
Function arguments¶
Arguments should be used in the same order as in the documentation. To skip an argument and use its default value, just omit it, but keep the comma. For example:
FUNCTION(a,b,c,d)
FUNCTION(a,b,,d)
Excel functions to avoid¶
Any Excel function can be used, but the following functions should be avoided:
OFFSETINDIRECTVLOOKUP
TODO: Explain why.
Available custom functions¶
applyCorrelationMatrixconcatenatePipeconfFormulaconfValuecreateProjectionNodescsvToTabledictdiscountexcelTableexpandFormulafeatherTotablegetFormulaFromConfiggetValueFromConfigisConfigEmptyloopTablemapExternalProjectionValuesmapProjectionValuesprojResultprojectionResultsToTablerebaseIndexrebaseValueresultsJsonToTablerunFromConfigslicesolveToZerosqlToTablesumOverIndexTableLookuptableSumIfstablevariableMatrix- cascadeProjectionValues