Skip to main content
Skip table of contents

DeriveEntry

 

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.