Versions Compared

Key

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

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

Image RemovedImage Added

Use this button to:

  • configure Pivot Grid Appearance (font, size, style, color, background color for captions and samples),

  • clear formats,

  • paste or copy formats,

  • perform period formatting (font, size, style, color, background color for period captions and period names),

Usage Hints

Applicable hotkeys you may use when working with a report.

...

Right click on any field header to set or reset a color

Image RemovedImage Added

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

...