About statistics field interdependency

Field	How the field contents are calculated
Revenue	Invoiced revenue+ Total accrued revenue
Cost - Expense	Cost - Expense
Cost - Item	Cost - Item
Accrued loss	Accrued loss
Value-added	Revenue- ( Cost - Expense+ Cost - Item+ Accrued loss)
Cost - Hour	Cost - Hour
Gross margin	Value-added- Cost - Hour

Definition unit	How the field contents are calculated
Gross margin	The values in the P&L Structurefields are controlled by the option selected in the Gross margin ratiofield on the Statementstab in the Project parametersform. For more information about the Gross margin ratiooptions, see Gross margin ratio.
Value-added	The values in the P&L Structurefields are controlled by the option selected in the Value-added ratiofield on the Statementstab in the Project parametersform. For more information about the Value-added ratiooptions, see Value-added ratio.

Definition unit

How the field contents are calculated

Gross margin

The values in the P&L Structurefields are controlled by the option selected in the Gross margin ratiofield on the Statementstab in the Project parametersform.

For more information about the Gross margin ratiooptions, see Gross margin ratio.

Value-added

The values in the P&L Structurefields are controlled by the option selected in the Value-added ratiofield on the Statementstab in the Project parametersform.

For more information about the Value-added ratiooptions, see Value-added ratio.

Field	How the field contents are calculated
Invoiced revenue	Invoiced revenue
Invoiced revenue - On account	Applies to projects where posting of on-account transactions is set to Profit and loss on the project group.
Total invoiced revenue	Invoiced revenue+ Invoiced revenue - On account
Accrued revenue - Sales value	Applies for projects where the Completed percentage assessment principle is selected on the project group.
Accrued revenue - Production	Applies for projects where the Completed percentage assessment principle is selected on the project group.
Accrued revenue - Profit	Applies for projects where the Completed percentage assessment principle is selected on the project group.
Accrued revenue - Subscription	Accrued revenue - Subscription
Accrued revenue - On account	Applies to projects where posting of on-account transactions is set to Profit and loss on the project group.
Total accrued revenue	Accrued revenue - Sales value+ Accrued revenue - Production+ Accrued revenue - Profit+ Accrued revenue - Subscription+ Accrued revenue - On account
Cost - Hour	Cost - Hour
Cost - Expense	Cost - Expense
Cost - Item	Cost - Item
Accrued loss	Accrued loss
Total cost	Cost - Hour+ Cost - Expense+ Cost - Item+ Accrued loss

Field	How the field contents are calculated
WIP - Cost value - Hour	WIP - Cost value - Hour
WIP - Cost value - Expense	WIP - Cost value - Expense
WIP - Cost value - Item	WIP - Cost value - Item
WIP - Accrued loss	WIP - Accrued loss
Total WIP cost	WIP - Cost value - Hour+ WIP - Cost value - Expense+ WIP - Cost value - Item+ WIP - Accrued loss
WIP - Sales value	Applies for projects where the Completed percentage assessment principle is selected on the project group.
WIP - Production	Applies for projects where the Completed percentage assessment principle is selected on the project group.
WIP - Profit	Applies for projects where the Completed percentage assessment principle is selected on the project group.
WIP - Subscription	WIP - Subscription
Total WIP sales	WIP - Sales value+ WIP - Production+ WIP - Profit+ WIP - Subscription
Gross WIP	Total WIP cost+ Total WIP sales
WIP - Invoiced - On account	WIP - Invoiced - On account
Net WIP	Gross WIP- WIP - Invoiced - On account

Field	How the field contents are calculated
Hour - Qty.	Hour - Qty.
Cost hour rate	Hour÷ Hour - Qty.
Hour	Cost - Hour+ WIP - Cost value - Hour
Expense	Cost - Expense+ WIP - Cost value - Expense
Item	Cost - Item+ WIP - Cost value - Item
Total consumption	Hour+ Expense+ Item
Payroll allocation	Payroll allocation
Invoiced on account	Invoiced revenue - On account+ WIP - Invoiced - On account

Field	How the field contents are calculated
Hour - Qty.	Hour - Qty.
Revenue hour rate	Revenue÷ Hour - Qty.
Value-added hour rate	Value-added÷ Hour - Qty.
Cost hour rate	Cost - Hour÷ Hour - Qty.
Gross margin hour rate	Gross margin÷ Hour - Qty.

Using statistics

General tab - P&L Structure

General tab - P&L Ratio definition

Profit and loss tab

WIP tab

Other tab

Hour rate tab

See Also