Skip to content

Edit Formula Sum

Edits a formula sum.

Permissions

Command KindNeeded User Kind
WriteAll

Parameters

NameTypeDescriptionRequiredDefaultValues
DimensionstringName of the dimension ([Dimension]).yes
FormulastringName of the formula ([Formula]). A formula is a flat structure of a dimension. A Formula is build of items and sums. Sums are calculated with functions.yes
SumstringName of the formula sum ([Sum]).yes
Caption1stringCaption 1no
Caption2stringCaption 2no
Caption3stringCaption 3no
Caption4stringCaption 4no
Caption5stringCaption 5no
Caption6stringCaption 6no
Caption7stringCaption 7no
Caption8stringCaption 8no
Caption9stringCaption 9no
Caption10stringCaption 10no
FactornumberA number value is changed via a factor ([NumberField].[Factor]). For example a factor of 1.25 adds 25% to the value.no
InputstringInput function, e.g. Rubric("Turnover") - Rubric("Costs") + ItemRange("10000","20000") - Item("110002")no
InvisiblebooleanIf 'True' the sum is not shown at output. The default value is 'False'.nofalse
NamestringNew name of the formula sum ([Name]).no
RubricstringAdditional text for classification ([Text]).no

Result

No fields

Code

text
EDIT FORMULA SUM
DIMENSION=[string, Needed]
FORMULA=[string, Needed]
SUM=[string, Needed]
CAPTION1=[string]
CAPTION2=[string]
CAPTION3=[string]
CAPTION4=[string]
CAPTION5=[string]
CAPTION6=[string]
CAPTION7=[string]
CAPTION8=[string]
CAPTION9=[string]
CAPTION10=[string]
FACTOR=[double]
INPUT=[string]
INVISIBLE=[boolean, default=false]
NAME=[string]
RUBRIC=[string]