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