Jump to content

Balance Forward

jacger

By jacger
in FileMaker Legacy fp3 and fp5

 Share

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

Recommended Posts

jacger Apprentice

jacger

Posted
Posted

I am trying to build a statement. I want to be able to show a summary of unpaid balances before a particular date then an itemized list of charges from that date with a grand total at the bottom. I have not been able to figure out the balance forward portion.

Any suggestions.

Link to comment
Share on other sites
LiveOak Grand Master

LiveOak

Posted
Posted

If you use a relationship to identify all unpaid balances before a particular date and use the Sum() function to add up all these balances, the results won't be dependent upon the layout part in which it is displayed. You can then have just the itemized list of charges in the found set. The grand total could be = GetSummary(Add up found set) + Sum().

-bd

Link to comment
Share on other sites

This topic is 8559 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
Go to topic listing
×
×
  • Create New...

Important Information

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

  I accept