Sales Statistics and Revenue Statistics (BTB)

You can use the table in the Sales Statistics and Revenue Statistics info areas to store other data in tabular form.

However, seeing as several columns and fields have intrinsic functions associated with them (for example the difference in revenue between years is calculated automatically), you can remove these calculations from the columns and fields. These fields are not editable by default; however by removing the associated business logic, you can use them as you would use any numeric field.

Furthermore, you can determine that those fields that otherwise display percentages are displayed as standard numerical fields. In practice, it makes little sense to change the field type unless you also allow these fields to be edited.

Do not determine prices/discounts

This option is used to remove the connection between a field or column and the associated business logic. You need to enter the numbers corresponding to the fields or columns separated by a semicolon. For example, entering "1" would prevent the deviation from the previous year from being calculated as a percentage and the fields in the column can be edited.

Value	Sales Statistics	Revenue Statistics
1	Qty.Dev.%	Rev.Dev.%
2	Qty.Dev.Abs.	Rev.Dev.Abs.
3	Act. Qty. Cum.	Act.Rev.Cum.
4	Qty.PY.Cum.	Rev.PY Cum.
5	Qty.Dev.Cum.%	Rev.Dev.Cum.%
6	Qty.Dev.Cum.Abs.	Rev.Dev.Cum.Abs.
7	Prev.Qty.Date	Rev.Plan Date
8	Tot. Act. Qty.	Tot. Act. Rev.
9	Tot.Qty.PY	Total Rev.PY
10	Tot.Qty.Dev.%	Total Rev.Dev.%
11	Tot.Qty.Dev.Abs.	Total Rev.Dev.Abs.
12	Qty. Act. Plan	Act. Rev. Plan.
13	Qty.Plan PY	Rev.Plan PY
14	Qty.Targ.Perf. %	Act. Rev. Targ. %
15	Qty.Targ.PY %	Rev.Targ.Perf.PY %

Numeric Field

This option is used to define percentage fields as a numeric fields. The values in the field are then no longer displayed with a percent sign.

The following values are used by the Numeric Field option:

1	Qty.Dev.%	Rev.Dev.%
Value	Sales Statistics	Revenue Statistics
2	Tot.Qty.Dev.%	Total Rev.Dev.%
3	Qty.Targ.Perf. %	Rev.Targ.Perf.Curr %
4	Qty.Targ.PY %	Rev.Targ.Perf.PY %