Workbook Formula Examples
This topic provides examples of formulas created with the formula wizard. The examples are based on the Invoice Analysis data model.
| Example | Example with values | Example with cell references |
|---|---|---|
|
Average of quantity sold in 2017. |
|
|
|
Average of quantity sold in 2017 for customer codes AO001, AO002, and AO003. |
|
|
|
Average of quantity sold in 2017 or 2018 for customer codes AO001, AO002, and AO003. |
|
|
|
Average of quantity sold between 2015 and 2018 for customer codes AO001, AO002, and AO003. |
|
|
| List of company names with a sold quantity equal to or higher than 500 in 2017. | 
|
|
| Sum of quantity sold during the last six months of 2018 or the first five months of 2019 (12-month rolling trend). | 
|
|
| Last date of invoice in 2018 for customer code AO001. | 
|
|
| First date of invoice in 2018 and customer code AO001. | 
|
|
|
Sum of the ledger currency cost for the third quarter of 2018 for all company codes. The asterisk (*) is used for ALL. |
|
|
| Count of orders made between January 1, 2017 and January 5, 2017. | 
|
|
| List of orders made on January 5, 2017. | 
|
|