Fast way to total the invoice balance base on the found records

[chadski021]

Is there a fast way to calculate all the invoicebalance listed base on the found records?

here is my current process

 

Enter FindMode

SetField ( invoice layout::Invoice Balance > 0 )

Perform Find

Set Variable:

Name: $currentBalance

Value:

Let (
    [
        ~list = ListValues ( invoice layout::Invoice Balance ) ;
        ~total = TotalList ( ~list )
    ];

        #AssignGlobal ( # ( "currentBalance" ; If ( IsEmpty ( ~total ) or ~total  ≤ 0 ; 0 ; ~total ) ) )
)

 

But this process takes a while to finish if i have 10 record in the found records

[comment]

Why don't you simply use a summary field?

 

--

Note: posting a calculation that references custom functions, without revealing how these are defined, does not bring us closer to understanding the problem.

[chadski021]

I used summary previously but it is loading once i go to other records.

[comment]

  On 3/30/2015 at 9:20 AM, chadski021 said:

but it is loading once i go to other records.

 

?

[chadski021]

  On 3/30/2015 at 12:03 PM, comment said:

?

I see a another summarizing window once i used summary field.

[comment]

  On 3/30/2015 at 2:41 PM, chadski021 said:

I see a another summarizing window once i used summary field.

 

I am afraid I have no idea what you're saying - neither here nor in your previous post. I suggest you describe the problem in more detail. Being laconic is not a good policy when asking for help.

[chadski021]

Sorry about for my bad grammary if you can't understand it clearly. i will update this later.