1 2 Previous Next 21 Replies Latest reply on May 9, 2017 9:43 AM by fmpdude

    Counting filesize of containers with custom function


      I am setting up a script that counts the filesizes of the files in the containers of related child fields.  I currently have calculation fields in each of the related records that gets the FileSize using


      GetContainerAttribute ( Statement ; "FileSize" )


      and then summing them with a calculation field in the parent table


      Sum (Merchants_BankStatements::_cFileSize)


      I'm trying to set this up instead with a custom function that uses lists and recursion but I can't figure out how to do it.  Here's what I have so far for my custom function.  What am I doing wrong? The number that it's returning is way too big.


      ProcessRecursively (theList ; start)


      Let ( [

        $i = start + 1 ; // initialize counter

        curVal = GetValue ( theList ; $i ) ;

        result = curVal  // process somehow, e.g. multiply

        ] ;


        Case (

          $i    ≤  ValueCount (theList) ; result +

          ProcessRecursively ( theList; start +1);  )



      I'm calling the function like this BTW


      ProcessRecursively (List (Merchants_BankStatements::Statement ; 0))

        1 2 Previous Next