Specify Operation or a Permitted Expression Between the Hashes
Formulas can contain expressions that refer to some variables in the program. Variables are entered between two hashes (#) by convention.
A set of variables is linked together using mathematical operators (see Formulas) or logical symbols (see Using logical expressions in formulas). Of course, we also list all the allowed terms in between hashes – variables that the program searches for (for a detailed list of allowed terms, see Verifying formulas in financial reports, Verifying formulas in posting templates, and Pricing formulas) .
The formula test expects one of these characters to appear between two hashes (#).
If this condition is not met, the formula test returns this error.
When we click the OK button, the program places the cursor on the spot in the formula where the error occurred.
There is a proposed solution. Check the formula: a set of variables is linked together using mathematical operators or logical symbols.
| Correct |
Incorrect |
Missing |
| #A3#+#A4# |
#A3##A4# |
+ |
| #A3#+#A4# |
#A3#+## |
A4 |
| #PRICE#*#QUANTITY# |
#PRICE##QUANTITY# |
*
|