By using this website, you agree to our Terms of Use (click here)
We have recently been getting this error, "Type mismatch in the expression: '-'.", when a calculation in a column attempts to subtract one column from another, i.e.: =B-C. Both columns B and C are GL column types. The formula =B+C works but the formula =B-C does not.
Has anyone encountered this error before?
Hi, Patrick -
It looks like there may be no value in C when you get the message. Check whether some new data has a missing value in that column/field.
You could also try =B-IsNull(C,0) in place of =B-C. If that works, then missing data was the issue and translating it to zero might be an appropriate solution.
Hi Dianne,
We have added a couple of accounts that do not have transactions yet.
I have tried forcing a zero value of the column is null but that does not work either.
Any suggestions?
Hmm... Are both columns actually numeric? I'd check the DAC to be sure, though it may be obvious if they are actually dollar amount fields.
What happens if you explicitly cast them to Decimal or Double? =CDbl(B) - CDbl(C)
If I cast them to Double I get tis error:
| An error has occurred while the CDbl(Identifier(B)) function was being executed: 'Input string was not in a correct format.' |
This is an ARM report so the data source for both columns being GL and turnover should return numeric data.
I'm going to submit a case to Acumatica and let everyone know what the outcome is.
Because it's a recent development, there must be some new data value throwing things off. Good luck!
The resolution to this issue was not in the Column Set but rather in the Row Set.
A user had added a row referencing another row without the "=" sign.
i.e., @002200 instead of =@002200