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 |