Table function
Use a Table function to add together values from cells in a table and display the sum in your scorecard. A Table function can be applied to any table. When applied to a Query table it allows you to present figures in your scorecard that are stored in an external database, e.g. daily production figures that are always up to date.
How to create a Table function
Table Functions can be created under status elements (Status, Simple status, and Function status). Right click the status object to which it belongs and choose Add -> Table Function.
Properties
General
-
Name - the name "Table function" is automatically generated but it may be changed
-
Description - an optional text describing the function
-
Table - click the icon to the right and choose the table to be used
-
Function - the range specifying which cells in the table to include. E.g.
-
to include a specific group of cells specify the upper leftmost and lower rightmost cells in the selection, e.g. A1:D3
-
to include all cells in column B write B1:B?
-
to include all cells in the entire table write A1:??
-
-
Format - enter optional formatting information (Prefix, Type, Decimal, Postfix, and/or Color) (Format type, Prefix, Postfix, Decimal places, and/or Color style). If nothing is entered Type, Decimal, and Color Format type, Decimal places, and Color style will have the default values "Normal", "2", and "Normal".
-
Node type - click the icon to the right and choose from the node types Actual, Budget, Forecast, or Target, in addition to custom node types that may have been created in your system.
Visibility
-
Visible - select how the object should appear on the web:
-
Visible
-
Not visible
-
Only visible for Admin - shows the object on the web only for users with admin user role; this applies everywhere, e.g. breadcrumb, organization tree, page content, Reporter, searching, filtered lists, maps, and Workflow.
-
This can be useful e.g. when adding new elements to "live" objects.
Audit
-
Modified by - the name of the last user to make changes to the object.
-
Last modified - the date and time when the object was last changed.
-
Created by - the name of the user who created the object.
-
Created - the date and time when the object was created.
Advanced
ID
-
ID - a unique ID for the object.
By
default, Corporater BMP assigns consecutive numbers to new objects. You can change the ID to a value of choice that can include either letters or letter and number combinations.
The ID mustn't contain only numbers, include special characters such as ) ( . * } { + < > [ ], or match the name of a default object type in Corporater BMP.
Visibility
-
Show Menu Button - check if you want the button that opens the Options menu for the object to be available on the web page; among other things, the Options menu contains alternatives for editing and deleting. The contents of the Options menu can be configured in Page setup.
Access control
-
Read accessors - click the Edit button (
) and authorize one or more users and user groups to view the object on Web. -
Add accessors - click the Edit button(
) and authorize one or more users and user groups to add new objects to the object on Web. -
Write accessors - click the Edit button(
) and authorize one or more users and user groups to edit the object on Web. -
Delete accessors - click the Edit button(
) and authorize one or more users and user groups to delete the object on Web. -
Ownership - click the Edit button (
) and grant ownership of the object to one or more users and user groups. Users and user groups who own the object have full access rights to it.
-
Override access profile - select for the object's access control setting to outrank the object's corresponding access settings in profiles.
