Sales Analysis calculated measures and KPIs

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

The saved expressions use the invoice date and sum aggregation.

Measure	Description
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