Excel to Analytica Mappings/Database Functions

This page shows how selected database functions in Excel map to Analytica equivalents.

DAVERAGE(table,field,criteria)

Analytica equivalent:

Mean( table[FieldIndex=field], RowIndex, w:criteria )

DCOUNT(table,field,criteria)

Analytica equivalent:

  [[Sum]](criteria, RowIndex )

where criteria is a Boolean comparison involving the table[fieldIndex = field] that evaluates to 0 or 1.

DGET(table,field,criteria)

Analytica equivalent:

table[FieldIndex=field,RowIndex=SubIndex(criteria,1,RowIndex)]

DMAX(table,field,criteria)

Analytica equivalent:

CondMax(table[fieldIndex=field],criteria,RowIndex)

DMIN

Analytica equivalent:

CondMin(table[fieldIndex=field],criteria,RowIndex)

DPRODUCT(table,field,criteria)

Analytica equivalent:

Product( If criteria Then table[FieldIndex=field] Else 1, RowIndex )

DSTDEV(table,field,criteria)

Analytica equivalent:

SDeviation( table[FieldIndex=field], RowIndex, w:criteria )

DSUM(table,field,criteria)

Analytica equivalent:

Sum( If criteria Then table[FieldIndex=field] Else 0, RowIndex )

DVAR

Analytica equivalent:

Variance( table[FieldIndex=field], RowIndex, w:criteria )