Type Mismatch Error on Formula (2 replies)
TJ, the likely culprit here is that you have set the ALLIN field to type Text and there is a record which has an empty value AND the field is returning a string.
https://www.realisable.co.uk/support/Documentation/iman-user-guide/DataConcepts/FieldTypes.htm
You have two options:
a. Change the field type to a numeric type.
b. Have a formula which does a conversion, such as:
IIf(%ALLIN = "", 0, %ALLIN) * -1
IIf(%ALLIN = "", 0, %ALLIN) * -1
Beauty - Thanks Realisable! option a didn't work for me, but option b worked perfectly!
Hi, I have receive the error 'Type mismatch '[string ""]' on the following formula.
%ALLIN*-1
What's wrong?