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 |