Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have three fields in my script which are numbers. I've confirmed this by doing "isnum()" on each of the fields. They are the 3 columns on the right in this screenshot. However, in my script i am creating a new field called test by doing this: BPtest&MRNtest&datetest as test.
However, there are some results that are no longer considered numbers. If I do num(BPtest&MRNtest&datetest) as test in my script, those instances do not generate any number and are null. Any ideas why if the subparts are numbers why the whole isn't? And any ideas how to solve this?
