Sum function with nonnumeric data (AREV Specific)
At 19 MAY 1999 09:45:08AM Mark Watford wrote:
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.
At 19 MAY 1999 11:12AM Matt Sorrell wrote:
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
At 19 MAY 1999 12:12PM Victor Engel wrote:
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.