 # ValueMath ( List1 ; List2 ; operation )

Do mathematical calculations on corresponding members of two value lists     Average rating: 3.3 (4 votes) Log in to vote Bill Thurmes - Show more from this author MDCA http://www.miyotadca.com
Sample input:
ValueMath ( "8¶7¶6¶5" ; "6¶5¶20¶20¶20¶20¶14¶0¶5¶10¶10" ; "*" )
ValueMath ( "8¶7¶6¶5" ; "6¶5¶0¶20" ; "/" )
ValueMath ( "8¶7¶6¶5" ; 2 ; "^" )
ValueMath ( "8¶7¶6¶5" ; "" ; "^" )
Sample output:
48¶35¶120¶100
1.333...¶1.4¶?¶.25 --note: divide by 0 gives ?
Result: 64¶49¶36¶25 --note: acts like Extend
Result: "" --an empty value list results in an empty result

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Use two value lists and multiply/divide/add/subtract/(raise to power) them together, value position by value position
The result is a new value list with the results of each math manipulation
Note: If one List is only one member long, this function will work like Extend, i.e., apply that value with operation to all members of other list
Note: If both lists are >= 2 members long but are not the same length, concatenate the longer list

I later (Feb 2019) renamed this ValueArithmetic because it was a better description of what the CF does