| Widget Connector | ||
|---|---|---|
|
...
To re-create your profit & loss report in flex.bi you must follow these instructions.
...
but the " + " defines Sum of Accounts or Account Groups , but it can be also " - "
Info Account group
(10 + 20)means the Sum of Account Groups created before (means that lines 10 + 20 are included in this group).
...
- As well as these can be Sum of Accounts
...
| Note |
|---|
| Important : In HansaWorld reports lines can not be defined by Object limitations - In Flex.bi can |
...
To recreate your account groups in flex.bi you will need to create Calculated members that aggregate the accounts you need into groups. First you have to pick a group you want to re-create, always try to work with one group at a time to make this task easier. By default you will have the groups Asset, Liability, Equity, Income and Expense created for you already. This example will contain several methods of aggregating accounts into groups:
...
Now you will have to create a calculated member, calculated members are explained in detail here.
Create the following calculated member by entering the accounts by clicking on the bookmarks and connecting them with the ":" to create an interval.
| Info |
|---|
|
...
You should see the following result.
2. Defining SUM of Accounts or Account Groups
...
You should see the following result:
...
| Info |
|---|
You can also include those in Aggregations or SUM. You can limit also by any other dimension existing - dividing by "," . For example: Account 211 , Object Audio , Object Other etc |
...