Skip to end of metadata
Go to start of metadata
 

SuperCROSS

Production System

SuperWEB2

Element

Format

Description

Save

Load

Load

Save

Load

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

 YesYes

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

YesYesYes

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