AnsweredAssumed Answered

How to right a recursive custom function to do some math on an array

Question asked by dsvail on Mar 10, 2017
Latest reply on Mar 11, 2017 by beverly

need help writing or finding a custom function to do some math on a list of values gotten from an ExecuteSQL calculation. 

 

list looks like this ....

 

5,4

5,8

1,11

6,6

 

want to walk through the list and multiply the two value together and then sum the results together ... the number of list values can vary. 

eg. (5*4) + (5*8) + (1*11) + (6*6)  = 107 .

 

Thanks all

Outcomes