Jump to content

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


This topic is 2805 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2805 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.