Basic Calculations

Basic Calculations is a customized rule to run calculation based on customer's needs.

For a detailed description of all available Business Rule options see Basic Calculations - detailed reference.

Changes in Dimension Hierarchies must be Deployed for Business Rules to work correctly.

  1. Go to Dimensions → Account → create statistical account/accounts that hold the calculation results.
  2. Create Business Rule:
    1. Business Rule tab → fill in Business Rule's info.
    2. Steps tab :
      1. select the statistical accounts in Destination.
      2. setup operators & calculation accounts.
      3. Save → Run (to run the business rule).

  1. First we need to create the statistical account that hold the calculated result.
    Click on DimensionsAccount → Select Statistical Accounts and right click on it → NewLeaf → Fill up info. → CreateSave.
  2. Click on Business RulesNewBasic Calculations.
  3. Fill in
    • Name & Description (Mandatory)
    • Type = Basic Calculations
    • Comment
    • DataClass = Financials (Mandatory / which model you want this business rule to run)
    • Main Dimension = Account (Mandatory)
    • Fixed dimension = BusinessProcess=BR_OUTPUT
    • Dimension filter
  4. Click on Save button at the right bottom.
  5. Click on the new rule from Rule nameSteps tab → New destination
  6. Expand the account hierarchy and select the destination account (mostly statistical accounts), like below example → click on Apply.
  7. Click on New Step → select the calculation accounts & calculation method → Apply button → then Save button at the right bottom.
    • Operator: the mathematical operator for the formula.
    • Dimension Filter : you can include or exclude dimensions from the business rule. Also, you can set the dimension to store the result of the business rule.
  8. Go back to Business Rule tab and click on *Save* button again to save this business rule.
  9. Click on Run button when you want to run this business rule.

In above example, we need to get the Gross margin percentage, so formula would be Gross margin/sales revenue.
You need to get these two accounts in the step sections and apply the relevant operator, so result will be saved in the destination you selected after the steps are done.
You can go to the Business Rules tab and run the rule for the specific period, then you can go to the Excel and extract information to see the result instantly.

Cashflow business rule is bit advance and vary with the customers reporting practice, here we have illustrated generic cash flow statement. In this Example we have replicated the cash flow statement template as it is in the destination, that means we chose cashflow statement accounts as our destinations in the business rule, in other words, the result of the business rules will be saved in the cashflow statement accounts. Once you got the relevant destination accounts, you have to calculate the relevant formula, mainly in the cashflow, you need to get the movements of two accounts or getting the right balance from P&L or Balance sheet.

In this example, we need to calculate salary from two variables, one is annual salary, the other one is payroll days (both have been created as statistical accounts and loaded values from input sheet ), so we have taken thees two accounts under steps tab, and formula is Annual salary divide by no of working days into payroll days for the respective month, and also you can see that there is dimension filter for Payroll days, which is = Employee='NONE', this means we have removed employee dimension from this account because we have not loaded payroll days by employee, but we did load annual salary by employee, therefore you have to remove the dimension if both accounts dimensions are not the same.

Here destination is one of the GL account, so the result of the calculation will be saved in this GL account.

  1. Select AR Accounts in the Steps (New steps > select AR Account).
  2. Choose Movement in the modifier.
  3. Or as an alternative – if you want both opening and closing in cash flow statement.
  4. First Opening: Select AR Account – “Modifier” Month -1 – “Multiply with” -1 since it should be subtracted out of…
  5. Second Closing: Select same AR Account.

  • v2/admin/br-01.txt
  • Last modified: 2021/06/09 09:35
  • by pcjamo