| Widget Connector | ||
|---|---|---|
|
...
To re-create your profit & loss report in flex.bi you must follow these instructions.
...
The symbol ":" between two account numbers Interval of Accounts or Account Groups
The example shown in the image above :Info Accounts (100:199) means that it is interval of the accounts from 100 to 199
(100, 101, 102, 103, ... , 198, 199) are included in this group
...
| 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
...
Important : In HansaWorld reports lines can not be defined by Object limitations - In Flex.bi can
...
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 |
...