Chrono reports are the static reports with the date in columns and the data in rows. These reports are used to create static report tables to match business standard templates.
...
The Chrono Reports workspace consist of four main tabs with different functionality, the toolbar, and Errors List. Detailed description of these reporting components see below.
Table of Contents |
---|
...
Add New Chrono
To create this type of report select "Chrono Report" from Add Report button dropdown.
...
Button | Icon | Description |
---|---|---|
Find and Replace | <CTRL>+ H. Use this icon to quickly update a range of selected cells when editing or updating reports | |
Convert to Static Report | Convert your report to static. Note that if your report currently has errors, they must be resolved before the report can be converted to a static one. See the Errors list below. | |
Manage Custom Lists | Opens Custom Lists dialog where you may add, remove, move up/down, save and import custom lists, as well as add, remove, move up/down, sort, copy, paste and clear custom items. | |
Formatting | Use this button to:
| |
Usage Hints | Applicable hotkeys you may use when working with a report. |
...
Right click on any field header to set or reset a color | |
Right click on any field row to copy its full name |
...
Available formulas | |||
---|---|---|---|
V("prod.wt.ore") | Returns the value of "prod.wt.ore" in the current period | ||
PV("prod.wt.waste") | Returns the value of "prod.wt.waste" in the previous period | ||
CV("prod.wt.waste") | Returns the cumulative values of "prod.wt.waste" up to and including the current period | ||
CPV("prod.wt.waste") | Returns the cumulative values of "prod.wt.waste" up to the previous period (excludes current period) | ||
S("prod.wt.*") | Sums all child fields of "prod.wt" in the current period (using asterisk as a wildcard for all children) | PS("prod.wt.*") | Sums all child fields of "prod.wt" in the previous period (using asterisk as a wildcard for all children) |
SD(V("value1"),V("value2")) | Safe Divide value1 by value2. If value 2 is zero, the result is zero | ||
Math.Round(SD(V("value1"),V("value2"))) | Safe Divide result is rounded to the nearest even integer | ||
Math.Ceiling(SD(V("value1"),V("value2"))) | Safe Divide result is rounded up to the ceiling | ||
Math.Floor(SD(V("value1"),V("value2"))) | Safe Divide result is rounded down to the floor | ||
V("myValue") > 0 ? 1 : 0 | If "myValue" is greater than zero, return one, otherwise return zero |
...