Example 2
The example shows the input parameters in a
general fGetVal function defining a calculation account.
=cc.fCalcVal(sPer,sAct,sComp,sCurr,sAcc,sDim1,sDim2,sDim3,sDim4,sJtyp,<cellref >)
The formula’s parameters can consist of various items of input data:
- All parameters except <acc> and <cellref> can be an IBM® Controller function, a string or a cell reference
- The parameter sAcc can be a string or a cell reference
- The parameter <cellref> can be a string containing a relative Microsoft Excel reference.
The following report formula shows how a value is saved in the CALC account CALCT040:
=cc.FCalcVal(’0012’,’AC’,cc.fComp(3),$E43,’CALCT040’,cc.fDim1,’ ‘,’ ‘,’ ’,’ ’, ’$F$48’)
Where:
0012 = Period
AC = Actuality
cc.fComp(3) = The company in the 3rd system row/column in a report.
CalcT040 = Calc Account
cc.fDim1() = Dimension1, code, reference or function can be entered.
$F$48 = Reference to cell containing the value to be stored.
- The account must be a statistical account, which means that only account types R, S, T and U can be selected.
- If you use an Controller function, for example, fComp(), as input in fCalcVal you will run the calculation for the company you choose to run it for on the Group/Calculate Report Formulas menu.
- Use the Save Between Formulas option (Group/Calculate Report Formulas) if you have several calculation reports that interact with each other. For example if a fCalcVal formula uses a value that has been calculated by another FCalcVal formula in another report.
Tip: The option Show Calculated Values(Group/Calculate
Report Formulas) gives you a preview of the calculated
values.