DeriveEntry

DeriveEntry

DeriveEntryDefine DeriveBody DeriveEnd

DeriveEntryDefine

'DERIVE' {'SUPPRESS'} IdentifierString

• IdentifierString – Display name for the derivation.
• SUPPRESS - Suppress Intersection flag

Yes

Yes

Yes

Yes

Yes
SUPPRESS is ignored

DeriveBody

DerivePriority {DeriveDecPlaces} {Footnote} (FieldDerivFormula | AxisDerivFormula)

DerivePriority

'PRIORITY' PositiveInteger

PositiveInteger – Order in which to calculate the derivations in. The hight the number the later the value is calculated.

Yes

Yes

Yes

Yes

Yes

DeriveDecPlaces

'DEC_PLACES' PositiveInteger

PositiveInteger – Number of decimal places to apply to the derivation cells. This will be used instead of the tables decimal places value.

Yes

Yes

Yes

Pass-through

Pass-through

FieldDerivFormula

FieldFormula BinaryOp FieldFormula

FieldFormula

UnaryOp '('FieldFormula')' | StatisticalOp | FieldFormula | FloatingPoint | 'sum('FieldItem':'FieldItem')' | FieldItem | FieldReferenceItem

Yes

Yes

Yes

Yes

Yes

FloatingPoint

Integer '.' PositiveInteger

FieldReferenceItem

'RefF('FieldItem')'

IdentifierString – field the derivation references.

Yes

Yes

Yes.

No (???)

Yes

AxisDerivFormula

FieldFormula BinaryOp FieldFormula

AxisFormula

UnaryOp '('AxisFormula')' | AxisFormula | FloatingPoint | 'sum('AxisItem':'AxisItem')' | AxisItem | AxisReferenceItem

Yes

Yes

Yes

No(???)

Yes

AxisReferenceItem

(('RefR' | 'RefC' | 'RefW' | 'RefWR' | 'RefWC' | 'RefRC') '('AxisItem')') | 'RefWRC'

Yes

Yes

Yes

Yes

Yes

StatisticalOp

StatisticalOpAll | StatisticalOpPercentile | StatisticalOpPareto | StatisticalOpForecast

Yes

Error occurs if ResultRange is not in the field recode.

Yes

Yes

StatisticalOpAll

('asymmetry' | 'mean' | 'median' | 'skewness' | 'stdrv' | 'variance')'('FieldItem':' FieldItem')'

Yes

Yes

Yes.

Yes

Yes

StatisticalOpPercentile

'percentile(' FieldItem':'FieldItem';'FloatingPoint')'

Yes

Yes

Yes

Yes

Yes

StatisticalOpForecast

'forecast(' FieldItem':'FieldItem';'FloatingPoint')'

Yes

Yes

StatisticalOpPareto

'pareto('FieldItem':'FieldItem';'Integer';'FloatingPoint')'

Yes

Yes

Yes

Yes

Yes

UnaryOp

{'round' | 'log' | 'exp' | 'sqrt'}

Yes

Yes

Yes.

Yes

Yes

BinaryOp

('+' | '-' | '*' | '/' | '%')

Yes

Yes

Yes

Yes

Yes

DeriveEnd

'END DERIVE'

Yes

Yes

Yes

Yes

Yes