ArrayCumSum ( array )

Return an Array with the cumulative sum of input Array (similar to MatLab CumSum function)

Be the first to rate this function Log in to vote

Felice Giusti - Show more from this author
R-Store spa

Sample input:

1
3
9

Sample output:

1
4
13

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

/*

Name:
ArrayCumSum

History:
Created by Felice Giusti - R-Store spa
Creation Date: 22/12/2024
ChangeLog:
23/12/2024: vers. 1.1 - Switched from local variables ($xxx) to "superlocal" (˜xxx) variables (at the suggestion of Danilo Lutti - R-Store spa)

Purpose:   
Return an Array with the cumulative sum of input Array (similar to MatLab CumSum function)

Parameters:   
array of numbers
 
Example: 
ArrayCumSum("1¶3¶9") = "1¶4¶13"

*/ 

While ( 
[ ˜arrayInput=Array ;
˜NuovoValore=RicavaValore ( ˜arrayInput ; 1 );
˜arrayOutput=˜NuovoValore;
˜i=2] ;
 RicavaValore ( ˜arrayInput ; ˜i ) ≠ "" ; 
[ ˜NuovoValore=Min(˜NuovoValore+RicavaValore ( ˜arrayInput ; ˜i );1);
˜i=˜i+1 ;
˜arrayOutput=˜arrayOutput & ¶ & ˜NuovoValore] ; 
˜arrayOutput )

Return an Array with the cumulative sum of input Array (similar to MatLab CumSum function)

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ArrayCumSum ( array )

Comments

Support this website.

Support this website.