Calculated measures and KPIs

This table shows the measures that are calculated and defined as saved expressions.

The Time dimension used in the expressions is based on the invoice date and sum aggregation.

Measure	Description
Avg Abs Catch Weight Var	Absolute catch weight variance divided by the invoiced quantity
Avg Catch Weight	Catch weight divided by the invoiced quantity
Avg Catch Weight Var	Catch weight variance divided by the invoiced quantity
Avg Nominal Weight	Net weight divided by the invoiced quantity
Catch Weight Var Pct	Catch weight variance divided by the net weight
Disc 1 Pct	Discount amount 1 divided by the invoiced gross amount
Disc 2 Pct	Discount amount 2 divided by the invoiced gross amount
Disc 3 Pct	Discount amount 3 divided by the invoiced gross amount
Disc 4 Pct	Discount amount 4 divided by the invoiced gross amount
Disc 5 Pct	Discount amount 5 divided by the invoiced gross amount
Disc 6 Pct	Discount amount 6 divided by the invoiced gross amount
Gross Margin 1 (Pct)	Gross profit 1 divided by the invoiced net amount
Gross Margin 2 (Pct)	Gross profit 2 divided by the invoiced net amount
Net Unit Price	Invoiced net amount divided by the invoiced quantity
Net Weight Price	Invoiced net amount divided by the net weight
Total Disc Pct	Total discount amount divided by the invoiced gross amount