Use Excel's database and list management functions in your Anaplan XL reports
| Function | Description |
| DAVERAGE | Shows the average of the values that meet the specified criteria. |
| DCOUNT | Counts the number of cells containing numbers that meet the specified criteria. |
| DCOUNTA | Counts non-blank cells containing numbers or text that meet the specified criteria. |
| DGET | Returns a single value that meets the specified criteria. |
| DMAX | Extracts the highest value that meets the specified criteria. |
| DMIN | Extracts the lowest value that meets the specified criteria. |
| DPRODUCT | Returns the product of the values that meet the specified criteria. |
| DSTDEV | Estimates the standard deviation of a population, based on a sample of selected entries from the database. |
| DSTDEVP | Returns the calculation of the standard deviation of a population, based on the sum of the whole population. |
| DSUM | Returns the total of the values that meet the specified criteria. |
| DVAR | Estimates the variance of a sample population based on values that meet the specified criteria. |
| DVARP | Returns the calculation of the true variance of an entire population based on values that meet the specified criteria. |
