Show TOC

Function documentationBasic Financial Functions Locate this document in the navigation structure

 

Use these basic financial functions to obtain an average account balance and an account growth rate.

Features

Planning and Consolidation contains the following basic financial functions:

  • AvgBal — Average balance

    Calculates the average balance of an account. This result can be used in other functions such as ROA, ROE, and others.

    *function AvgBal(%ACCOUNT%)

    ((closingperiod(month,ancestor(%Time_Dim%.currentmember,year).prevmember),%ACCOUNT%)+((%Time_Dim%.currentmember,%ACCOUNT%))/2

    *endfunction

  • Growth

    Calculates account growth rate. This result is used in sales growth, expense growth, and other functions.

    *function Growth(%ACCOUNT%)

    IIF((Parallelperiod(year,1,%Time_Dim%.currentmember),%ACCOUNT%)=0,null,

    ((%Time_Dim%.currentmember,%ACCOUNT%)

    (Parallelperiod(year,1,%Time_Dim%.currentmember),%ACCOUNT%))/(Parallelperiod(year,1,[TimeDim].currentmember),%ACCOUNT%)*100)

    *endfunction

Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.