Back to forum list… Back to Issues and Problems...

Error in formula. (1 reply)

Shraga Muller

6 years ago

Shraga Muller 6 years ago

We have a formula:

IIF (%TEXTTRX = 3 , -%AMTDIST , %AMTDIST)

IIF (%TEXTTRX = 3 , -%AMTDIST , %AMTDIST)

But are receiving the following error.

Error whilst evaluating field [AMTDIST] on transaction type [Record].
Resolved Function - IIF ("" = 3 , -"" , "")
Description: Type mismatch: '[string: ""]

Support

6 years ago

Support 6 years ago

Shraga, the issue is that at some point you have an empty value in the %TEXTTRX field and it cannot be converted to an integer.

You need to:

Find the value which is empty.
We recommend that you change the type of the field to an integer.

Thanks

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Request Demo

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Access Downloads

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Username
Password

	Remember Me Lost your password? Register