The Anaplan XL > Convert to > Formula option converts a grid report into Anaplan XL formula.
The Anaplan XL > Convert to > Values option converts an Anaplan XL Grid report into its values.
In Anaplan XL you can convert an existing grid report to a formula report.
To do this, right-click the grid, then select Anaplan XL > Convert to > Formula. Then select Yes to confirm that you want to convert the grid to a formula report.
If you are converting a grid report that contains slicers, a message that links to any slicers in the report will be removed is displayed. You can manually recreate these links.
To recreate links to slicers manually, follow these steps:
- Right-click the slicer and choose Edit slicer.
- On the settings tab, select Update range with selection and point to the cell location where the slicer choice is located.
- Select Caption from the dropdown.
- Edit your formula statement to point to this cell location. Right-click a cell in the formula report and edit the XL3Lookup statement to make sure the cell location which holds the slicer choice is correct.
