I am trying to write a formula to sum a multivalue field
which sometimes has nonnumeric data. By using an if statement
what is the wording to tell the formula to assign zero to the value
if it is nonnumeric or is there a better way to do this.
I am using AREV 1.16.
Mark,
This may not be the most efficient way to do it, but if I can't guarantee that an array will have all numeric data, then I set a variable=0, get the fieldcount on the array, loop through the array, test for IF NUM(val) and then add val to my variable if it is numeric.
Matt Sorrell
msorrell@movgal.com
There is a better way to do it.
X=SUM(Y)
is all you need. All non-numeric values in Y will be treated as zeroes. For example, SUM(123:@vm:'XYZ') is 123.