Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

“Belong together information” in a data structure are represented by square brackets on the left side. For data structures, the possibility exists , to produce several versions. Additional characteristics of a data structure can be created by clicking the "+" symbol. Superfluous data structures can be removed again by clicking on the “-“ symbol.

Entering table data

To enter data in a table form, click on a cell in the table.

There are two

...

ways for entering data in tables. By using totals calculation or manually entering all data.

Totals calculation 

Totals calculation enables values for subposition to be summed up. In order to use this feature, enable a checkbox "Totals calculation" and confirm the following dialog "Please note that values of totals positions might be changed if they are calculated by filled subposition values. Do you want to proceed?".

Summation occurs along

...

rows and

...

columns and

...

totals of a cell have to be equal along

...

rows and columns contributing to the total.

Cell, that got value as a result of summation, are

...

not editable and grayed. By clicking on it, you can see which cells are contributing to the value of that cell. By hovering on it, you get a message "Automatically calculated totals cannot be modified".

Image Modified

In case sums are not equal for both

...

rows and colums, an error

...

message appears in a cell. By clicking on it, you can see which cells are contributing to the sum and therefore easily find why the sums are not the same along both

...

rows and columns. By hovering on it, you get a message "The provided values sum up to different totals across rows and columns".

Image Modified

Manually entering data

...

When totals calculation is disabled you can manually enter data in all cells of the table.

Please disable checkbox "Totals calculation"

...

  to manually enter data. Then simply enter values in cells by clicking on them.

...

 

Image Modified

To change the worksheets, select a value in a pick list in the upper left corner of the screen, below the toolbar. Thus, the entered values in the table are associated with the worksheet for that dimension (for example, the client).

...