DeriveEntry
SuperCROSS | Production System | SuperWEB2 | |||||
---|---|---|---|---|---|---|---|
Element | Format | Description | Save | Load | Load | Save | Load |
DeriveEntry | DeriveEntryDefine DeriveBody DeriveEnd | ||||||
DeriveEntryDefine | 'DERIVE' {'SUPPRESS'} IdentifierString |
| Yes | Yes | Yes | Yes | Yes |
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 | Yes | 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 | Yes | 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 |