Location:  Forum Index » Database Schema & Business Logic » Calculation Engine (Define Fields) » Calculate percentage with subsummaries



252 Views    -    1 Replies


Username Post: Calculate percentage with subsummaries        (Topic#215872)
Your continued generosity and support of FMForums is greatly appreciated.
JMBell 
newbie
 Posts: 5



FMP: 8.5 Advanced
OS: Windows XP
Skill: Intermediate



Tweet This! Tweet This Post!
   This is JMBell's fifth post.
07-27-10 10:29 AM - Post#361540    


Hello

I have a report that runs an aging report for our invoices. In the report it shows a current (less than 30 days), 30 days, 60 days and 90 days past due with each timeline totaled by a summary of the total due and then a trailing grand summary at the end. I need to display a percentage of the total due for each timeline, i.e. a calculation of the amount 30 days past due divided by the total grand summary of all * 100 to get the percentage of the total due for each. Is there a way to do this? Thanks in advance!










Your continued generosity and support of FMForums is greatly appreciated.
comment 
consultant
 Posts: 15762
comment

Post Rank (AVG):
            


FMP: 7 Advanced
OS: Mac OS X Panther



Tweet This! Tweet This Post!
07-30-10 07:02 AM - Post#361808     - Post Rank:             
    In response to JMBell

Try a summary field defined as Fraction of Total of due amount.










Icon Legend Permissions Topic Options
Print Topic

Email Topic

252 Views
Welcome Guest...
Enter your username and password to login. If you do not have a username you can register one here

Username

Password

Remember me. Help



Forgot Password...


Quick Links
Recent Posts
Active Topics
No Replies
Recent Files
Functions & Scripts
FileMaker Pro Help
FileMaker on Twitter
FileMaker Marketplace

Custom Search

Find FileMaker Developers

Don't have time to wait,
hire a developer now!
Recent Members
Welcome them to our community!
Find FileMaker Jobs

Want a new career?
Find your new job now!
Joy of Tech
Latest Joy of Tech!

Recent Topics
Recent Hot Topics
Contribute
With your generosity we can make some real magic happen!. Support your favorite online FileMaker community...
FM Forums.com


Click here...

Or a Donation of any amount.


Thanks for your support!

Active Blogs
0 Recent blogs:
People to Post Lately in this Topic
JMBell
comment
Location:  Forum Index » Database Schema & Business Logic » Calculation Engine (Define Fields) » Calculate percentage with subsummaries
FM Forums Advertisers


FusionBB™ Version 3.0 FINAL | ©2003-2010 InteractivePHP, Inc.
Execution time: 0.643 seconds.   Total Queries: 40   Zlib Compression is on.
All times are . Current time is 08:34 PM
Content ©1996-2008 Ocean West Consulting, Inc. All Rights Reserved
Ocean West Consulting, Inc. can not and will not be held responsible for any of the contents in this site.
FM Forums™ is a trademark of Ocean West Consulting, Inc an independent entity, not affiliated with FileMaker Inc.
FileMaker® is a registered trademark of FileMaker Inc.
Top