Calculation Function List

Consult the Contents pane for a categorical list of calculation functions.

Table 2-15 Calculation Function List

Alphabetical List of Calculation Functions
@ABS @ISATTRIBUTE @NEXT
@ACCUM @ISCHILD @NEXTS
@ALLANCESTORS @ISDESC @NEXTSIBLING
@ALIAS @ISGEN @NOTEQUAL
@ALLOCATE @ISIANCEST @NPV
@ANCEST @ISIBLINGS @PARENT
@ANCESTORS @ISICHILD @PARENTVAL
@ANCESTVAL @ISIDESC @POWER
@ATTRIBUTE @ISIPARENT @PREVSIBLING
@ATTRIBUTEBVAL @ISISIBLING @PRIOR
@ATTRIBUTESVAL @ISLEV @PRIORS
@ATTRIBUTEVAL @ISMBR @PTD
@AVG @ISMBRUDA @RANGE
@AVGRANGE @ISMBRWITHATTR @RANGEFIRSTVAL
@BETWEEN @ISPARENT @RANGELASTVAL
@CALCMODE @ISRANGENONEMPTY @RANK
@CHILDREN @ISSAMEGEN @RDESCENDANTS
@COMPOUND @ISSAMELEV @RELATIVE
@COMPOUNDGROWTH @ISSIBLING @RELXRANGE
@CONCATENATE @ISUDA @REMAINDER
@CORRELATION @LANCESTORS @REMOVE
@COUNT @LDESCENDANTS @RETURN
@CREATEBLOCK @LEV @ROUND
@CURGEN @LEVMBRS @RSIBLINGS
@CURLEV @LIKE @SANCESTVAL
@CURRMBR @LIST @SHARE
@CURRMBRRANGE @LN @SHIFT
@DATEDIFF @LOG @SHIFTMINUS
@DATEPART @LOG10 @SHIFTPLUS
@DATEROLL @LSIBLINGS @SHIFTSIBLING
@DECLINE @MATCH @SIBLINGS
@DESCENDANTS @MAX @SLN
@DISCOUNT @MAXRANGE @SPARENTVAL
@ENUMVALUE @MAXS @SPLINE
@EQUAL @MAXSRANGE @STDEV
@EXP @MBRCOMPARE @STDEVP
@EXPAND @MBRPARENT @STDEVRANGE
@FACTORIAL @MDALLOCATE @SUBSTRING
@FORMATDATE @MDANCESTVAL @SUM
@GEN @MDPARENTVAL @SUMRANGE
@GENMBRS @MDSHIFT @SYD
@GROWTH @MEDIAN @TODATE
@IALLANCESTORS @MEMBER @TODATEEX
@IANCESTORS @MEMBERAT @TODAY
@ICHILDREN @MERGE @TREND
@IDESCENDANTS @MIN @TRUNCATE
@ILANCESTORS @MINRANGE @UDA
@ILDESCENDANTS @MINS @VAR
@ILSIBLINGS @MINSRANGE @VARPER
@INT @MOD @VARIANCE
@INTEREST @MODE @VARIANCEP
@INTERSECT @MOVAVG @WEIGHTEDSUMX
@IRDESCENDANTS @MOVMAX @WITHATTR
@IRR @MOVMED @XRANGE
@IRREX @MOVMIN @XREF
@IRSIBLINGS @MOVSUM @XWRITE
@ISACCTYPE @MOVSUMX  
@ISANCEST @NAME