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 |
|---|---|
| Invcd Net Amt per Unit Area – Transaction | Invoiced net line amount in the order currency per surface area (unit area can be any unit of measure) |
| Invcd Net Amt per Unit Area – Division | Invoiced net line amount in the division currency per surface area (unit area can be any unit of measure) |
| Invcd Net Amt per Unit Area – Company | Invoiced net line amount in the company currency per surface area (unit area can be any unit of measure) |
| Disc 1 Pct – Transaction | Discount amount 1 in the order currency divided by the invoiced gross amount in the order currency |
| Disc 1 Pct – Division | Discount amount 1 in the division currency divided by the invoiced gross amount in the division currency |
| Disc 1 Pct – Company | Discount amount 1 in the company currency divided by the invoiced gross amount in the company currency |
| Disc 2 Pct – Transaction | Discount amount 2 in the order currency divided by the invoiced gross amount in the order currency |
| Disc 2 Pct – Division | Discount amount 2 in the division currency divided by the invoiced gross amount in the division currency |
| Disc 2 Pct – Company | Discount amount 2 in the company currency divided by the invoiced gross amount in the company currency |
| Disc 3 Pct – Transaction | Discount amount 3 in the order currency divided by the invoiced gross amount in the order currency |
| Disc 3 Pct – Division | Discount amount 3 in the division currency divided by the invoiced gross amount in the division currency |
| Disc 3 Pct – Company | Discount amount 3 in the company currency divided by the invoiced gross amount in the company currency |
| Disc 4 Pct – Transaction | Discount amount 4 in the order currency divided by the invoiced gross amount in the order currency |
| Disc 4 Pct – Division | Discount amount 4 in the division currency divided by the invoiced gross amount in the division currency |
| Disc 4 Pct – Company | Discount amount 4 in the company currency divided by the invoiced gross amount in the company currency |
| Disc 5 Pct – Transaction | Discount amount 5 in the order currency divided by the invoiced gross amount in the order currency |
| Disc 5 Pct – Division | Discount amount 5 in the division currency divided by the invoiced gross amount in the division currency |
| Disc 5 Pct – Company | Discount amount 5 in the company currency divided by the invoiced gross amount in the company currency |
| Disc 6 Pct – Transaction | Discount amount 6 in the order currency divided by the invoiced gross amount in the order currency |
| Disc 6 Pct – Division | Discount amount 6 in the division currency divided by the invoiced gross amount in the division currency |
| Disc 6 Pct – Company | Discount amount 6 in the company currency divided by the invoiced gross amount in the company currency |
| Total Disc Pct – Transaction | Total discount amount in the order currency divided by the invoiced gross amount in the order currency |
| Total Disc Pct – Division | Total discount amount in the division currency divided by the invoiced gross amount in the division currency |
| Total Disc Pct – Company | Total discount amount in the company currency divided by the invoiced gross amount in the company currency |
| Gross Margin 1 Pct – Transaction | Gross profit 1 in the order currency divided by the invoiced net line amount in the order currency |
| Gross Margin 1 Pct – Division | Gross profit 1 in the division currency divided by the invoiced net line amount in the division currency |
| Gross Margin 1 Pct – Company | Gross profit 1 in the company currency divided by the invoiced net line amount in the company currency |
| Gross Margin 2 Pct – Transaction | Gross profit 2 in the order currency divided by the invoiced net line amount in the order currency |
| Gross Margin 2 Pct – Division | Gross profit 2 in the division currency divided by the invoiced net line amount in the division currency |
| Gross Margin 2 Pct – Company | Gross profit 2 in the company currency divided by the invoiced net line amount in the company currency |