I’ve been using a procedure for a long time with no problems. I recently added a round( function to take care of the occasional rounding error. Now part of the procedure no longer works.
this test:
round(val(array(lvSpecRate,1,tab()))/gvSalesTax,.01)+cr()+gvSalesTax
Where lvSpecRate is previously defined as a tab separated array, and gvSalesTax is defined as a number returns the expected numbers.
but when it the first put into a formula like this:
lvArSwiftSpec=lvArSpecial+¬+array(lvArNames,2,";")+¬+round(array(lvSpecRate,1,tab()),.01)+¬+ round(val(array(lvSpecRate,1,tab()))/gvSalesTax,.01)+¬+round((gvSalesTax-1),.01)
I get a “cannot divide text by a number” error.
The formula works fine when not using the array, which is the “normal” use, this is for nonstandard rates, the values of which are stored in a field and used to create the array lvSpecRate