You can use Excel formulas as well as Anaplan XL formulas in your Anaplan XL reports.
Anaplan XL Reporting Web Edition supports certain Excel formulas, as well as all Anaplan XL formulas. You can use the Excel function types below in your reports:
- Data and list management
- Date and time
- Engineering
- Financial
- Information
- Logical
- Lookup and reference
- Math and trigonometry
- Pre-Excel 2010 statistical
- Statistical
- Text
- Web
Web functions
| Function | Description |
| ENCODEURL | Returns the specified string as an encoded URL. |
| FILTERXML | Returns the selected node(s) from the specified xml and xpath expression. |
| WEBSERVICE | Returns the text result of an HTTP request from the specified URL. |
