Question on a Formula Query
I have a Formula query that is giving me the error message "Expecting Number." I expect that the field (159) is a number in my table. The record ID (108) should also be a number? Commented out on...
Forum Discussion
I'm certainly no expert on queries so this is just an educated guess but -
I suspect you are using a formula numeric field. I am surmising that the getfieldvalues call returns text no matter what. Someone else will have to confirm. So you are returining text. If you are sure it will only pull one value, wrap the whole thing in tonumber()
------------------------------
Mike Tamoush
------------------------------
I suspect you are using a formula numeric field. I am surmising that the getfieldvalues call returns text no matter what. Someone else will have to confirm. So you are returining text. If you are sure it will only pull one value, wrap the whole thing in tonumber()
------------------------------
Mike Tamoush
------------------------------
- Thanks Mike,
I tried ToNumber() and ToText() in a few places in the formula to no avail. I also tried changing the type of the filed
from Formula-Numeric to Formula-Text as a trial and that doesn't work either.
------------------------------
Chad Kragness
------------------------------- MarkShnier__You
Qrew Legend
please post your code by copy paste so its editable.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- GetFieldValues(GetRecords(108, [_DBID_TITAN_TIMBER_ITEMS]), 159));
//GetFieldValues(GetRecord(101, [_DBID_PROJECTS]), 5) sample from quickbase help.
Thanks Mark.
New to this forum stuff.
------------------------------
Chad Kragness
------------------------------
- Does this work:
ToNumber(ToText(GetFieldValues(GetRecord(108, [_DBID_TITAN_TIMBER_ITEMS]), 159)))
------------------------------
Sean Connaughton
------------------------------- MarkShnier__YouOK, so now we see your code, but can you say what you are trying to do with it? What's the goal?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
