I have a form that is giving the following error message on the title bar at the bottomof the Notes database: “Incorrect data type for operator or @Function, Number expected”
Since this message is displayed when the document first opens, I have checked the
PostOpen statement and have not located the problem.
I am assuming that this is in a formula somewhere or LotusScript code. Is there
some way that I can identify the issue without having to tear this form completely
apart?
Thank you in advance for your comments.
Jean
Subject: It’s a formula…
… and I would’ve expected it to tell you the associated fieldname if there is one. So perhaps it’s a computed text or something similar that has no associated field.
Probably the easiest way to track it down is to add a CFD field that uses @Prompt in its formula, and move it around on the form until you have bracketed the error – if the field’s prompt displays before the error, the problem is below the field.
BTW what I would probably do here is use the DXL Utilities in Designer to view the DXL of the whole form, and search for “<formula” to check out each formula, looking especially for anything that refers to a number field. I’m 90% confident that the problem is that you’re doing math on fields that aren’t initialized yet, e.g. Tax := Amount * 0.15 – and Amount is blank because you haven’t typed a value there yet.