| Key figures totalized by period | Description Note: Filter criteria Period is mandatory! |
|---|---|
| #Requests | The number of requests created in the month in question |
| #Participation hours | Sum of the hours (start time - end time) of all participations in the relevant period or month. |
| #Participants | Number of course requests that are enrolled in course units that fall within the relevant period or month |
| #Parts | Number of course parts carried out in the relevant period or month |
| #Customers | Number of different companies/persons who gave 'order' for an request in the period or month in question. |
| #Courses | Number of courses of which at least one part falls in the relevant period or month |
| #Training hours | Sum of the hours (start time - end time) of all course parts that fall in the relevant period or month |
| #Orders | Number of requests for which the status has been increased to 'Order' in that period or month |
| Invoiced | Sum of all invoices with the status 'Invoiced', of which the invoice date falls in the relevant period or month. |
| YearMonth | Aggregation of year and month (main number) |
| Not paid | Sum of all invoices of the status 'Invoiced' and 'Not paid', of which the invoice date falls in the relevant period or month. |
| Sales | Sum of all sales lines of requests with the status 'Order', of which the order date falls in the relevant period or month. |
| To be invoiced | [Sales] minus [Invoiced] (note: may be biased if either Sales or Invoiced do not fall into a selected period. |
| Expired sales | Sum of all sales lines of the requests with the status 'Expired', of which the expiration date falls in the month concerned |
| Expected sales | Sum of all sales lines of the requests with the status 'Concept' or 'Offered', of which the request date falls in the relevant period or month. |
| Costs | Sum of all purchase orders with status 'Order' (excl. VAT), of which the order date falls in the relevant period or month |
| Costs expected | Sum of all purchase orders with status 'Concept/offer' (excl. VAT), of which the creation date falls in the relevant period or month |
| Costs eliminated | Sum of all purchase orders with 'Expired' status (excl. VAT), of which the expiration date falls in the relevant period or month |
| Return | Sales - costs |
| Expected returns | ( Sales + Expected sales) - (Costs + Expected costs) |
De chat is even niet beschikbaar
