Sum function with nonnumeric data (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Sum function with nonnumeric data (AREV Specific) ====
=== At 19 MAY 1999 09:45:08AM Mark Watford wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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.
</QUOTE>
----

=== At 19 MAY 1999 11:12AM Matt Sorrell wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 19 MAY 1999 12:12PM Victor Engel wrote:  ===

<QUOTE>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.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0327D9F5D15F0DFF85256776004B8B3D|View this thread on the  forum...]]