I am having problems with a Procedure that should be adding Fields and making that Field Type Number (Float). My fieldtype “float” commands don’t change the field from it’s default of Text to Numbers (Float). Shouldn’t the fieldtype “float” in the Procedure make the Field Type a Numbers (Float)? I need it to be float for simple computations (at least I think that’s right). It has worked for me in the past in Procedures. I’m baffled.
Here is the Procedure:
addfield “PV”
fieldtype “float”
addfield “1 yr Fee”
fieldtype “float”
formulafill “PV"*.015
addfield “RMD+Fee”
fieldtype “float”
formulafill «RMD Current Year»+“1 yr Fee”
addfield “Cash”
fieldtype “float”
addfield “SELL”
fieldtype “float”
formulafill “RMD+Fee”-“Cash”
Here is the Procedure again with the problems:
addfield “PV”
fieldtype “float” : it is NOT making this Field Type: Numbers (FLOAT). When I go back to the field properties it’s showing as Type: Text (which is the default I guess)*
addfield “1 yr Fee”
fieldtype “float” : it’s NOT making this Field Type: FLOAT When I go back to the filed properties it’s showing as Type: Text*
formulafill “PV"*.015 : it’s not computing correctly: there is NO VALUE in the “PV” Field (I wish to enter values later) I want the formula to compute when I enter a value into the PV Field. It simply enters 0.015 in 1 yr Fee Field
addfield “RMD+Fee” : this does not work: it will NOT ADD this Field! Why??? I’ve tried giving this field a different name: like “RMD and Fee”. It still won’t add the field.*
fieldtype “float”
formulafill «RMD Current Year»+“1 yr Fee”
addfield “Cash”
fieldtype “float” (this works: the Type is indeed Number (Float). Perplexing.
addfield “SELL”
fieldtype “float”
formulafill “RMD n Fee”-“Cash” : I get error message: “cannot subtract number from text”
Help anyone? Thanks. Ed