The following error occurs in SAP Analytics Cloud (SAC): Formula could not be computed:Try rewriting the formula.
SAP Analytics Cloud 2020.8.15 and higher
Reproducing the Issue
Import a file ( like Excel) to model with a special character in the column name ( ' @ ", \ / ? * [ ] )
Create a formula on any of the measure with a special character in the column name
- Click Format and you will get the following error
Formula could not be computed:Try rewriting the formula.
This issue occurs due when the column name of your imported file has
the following special characters ( ' @ ", \ / ? * [ ] )
Remove the special characters from the column name either in the file to be imported or
in the import windows of SAC
KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem