Calculated measures and KPIs

This table shows the measures that are calculated in the cube:

Measure Description
Disc 1 % Discount amount 1 divided by the invoiced gross amount
Disc 2 % Discount amount 2 divided by the invoiced gross amount
Disc 3 % Discount amount 3 divided by the invoiced gross amount
Disc 4 % Discount amount 4 divided by the invoiced gross amount
Disc 5 % Discount amount 5 divided by the invoiced gross amount
Disc 6 % Discount amount 6 divided by the invoiced gross amount
Gross Margin 1 (%) Gross profit 1 divided by the invoiced net amount
Gross Margin 2 (%) 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 % Total discount amount divided by the invoiced gross amount