The line number must be an integer (#xx#)!
The line number must be an integer (#xx#)!
The line number must be an integer (#xx#)!
Performing formula testing in financial reports checks for correct syntax and whether the operand between the hashes is valid.
When referring to values in either A or B column, the reference has to be formatted as follows:
| First character |
Followed by |
|
A - value in column A (formula 1)
B - value in column B (formula 2)
|
an existing line number:
10
Only integers are valid. No wildcards are allowed.
|
Similarly, when performing formula testing in posting template except that only column A is available, column B does not exist.
The operand that failed the validation is shown in the error message. Focus is shifted to the record in question.
Clicking OK, the cursor shifts to the place in the formula where the error occurred.
Solution:
Enter a valid line number for referencing.
Examples:
| Correct |
Incorrect |
| #A31#+#A32# |
#A3%# |
| #A31#+#A32# |
#A3[1,2]# |
| #A31# |
#A# |