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) |