Jump to content

Recommended Posts

  • Newbies

Hello FM geniuses,

I've been trying to work out the solution to this issue for a few months now, and am losing my mind!

Essentially, in Table A I have a summary field of the total sum of commissions (all records).

I want to show that data in a sub-summary part in Table B (sorted by Month).

It seemed that using a Looked-Up Value would provide the solution I need, but alas, it doesn't even display the data.

Apologies if my explanation is lacking important details. Please let me know and I'll do my best to elaborate further.

For the record, I'm using FileMaker Pro 18 Advanced on Mac. This database is used on a desktop, and I'm the only one using it.

Thank you in advance!

Filemaker - Related Records Example.jpg

Link to post
Share on other sites
8 hours ago, Jay86 said:

in Table A I have a summary field of the total sum of commissions (all records).

A summary field does not total all records. It totals only records of the current found set. And when you use a summary field defined in a related table, it will return the summary of the related records only. In your example, the summary field is defined in a parent table, so it will return the value of the summarized field in the parent record (which is not very useful).

Not sure what exactly you are trying to accomplish here. A worked out example - with meaningful names for tables and fields - could be helpful.

Link to post
Share on other sites
  • Newbies

Let me offer a little more clarification.

Table A holds our SALES RECORDS and TABLE B shows a PROFIT & LOSS STATEMENT.

Table B has a range of different fields, but I want to add a few fields from TABLE A (commissions, revenue, profit etc) to show a full financial picture.

 

Link to post
Share on other sites

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
  • Similar Content

    • By ken_s2007
      I'm not well versed in summary layout parts and reports, but am trying to learn.
      I have a (personal) database to track investments (stocks, mutual funds, bonds, etc.). I have fields such as: number of shares, price, and value (technically: shares * price). Each record has three checkboxes: buy, sell, and current holding (previous (historical) records do not have 'current' checked).
      After establishing a found set (of a particular investment), I have a script that constrains the found set to buys, sells, and current record(s) (plural, because the same investment could be held in multiple accounts). (All historical records (except buys and sells) are thus not in the found set.)
      I have a script, triggered on layout enter, that sorts by buy, sell, and current. (Buys and sells are executed trades.)
      I have a sub summary part, and in it, a summary field based on value.
      The layout displays the records sorted as I want, and the summary field displays the correct total for each of the three groupings of records.
      What I want is to get the value of each of those summary fields, so that I can do a calculation: (Sells + current holding) - buys = profit / loss.
      Of course using the single summary field doesn't work.
      I could run a script to find the buy records, set a variable based on the summary field value, find the sell records, set a variable on the summary field, and so on. Then have fields with those variables (plus a calculation field) in the trailing grand summary.
      I could also create separate fields for buy (shares, price, and value), sell, and current, but I'd prefer not to.
      I thought I'd ask, because I might be missing a simpler method. thanks
    • By Richard Carlton
      Summer is over and our weekly FileMaker webinars are back! 

      Our first one is this Thursday at 11am PDT, on “Relationships for Beginners”. 

      Register Here: 
      https://attendee.gotowebinar.com/register/6892433068111504642 

      We will spend 30 minutes covering a specific topic. Then the last 30 minutes will be an open Q&A on any topic.

      Topic List:
      Sept 13th: Relationships for Beginners
      Sept 20th: Find Records, Date Ranges, and Special Operators
      Sept 27th: Conditional Formatting (Can I making something Red?)
      Oct 4th: Automation (Repetitive Tasks can become Scripts)
      Oct 11th: Reporting & SubSummaries
      Oct 18th: Merge Fields and Hiding Objects (Harry Potter Invisibility Cloak)
      Oct 25th: Sharing your FileMaker App with Co-Workers
      Nov 1st: Basic Concepts for Building Mobile Apps


      All the best, 
      Richard Carlton 
      CEO & Video Trainer
    • By ggt667
      How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html
      I'm able to grab the content from the first subsummary, not the remaining however.
      The following:
      set field( output; GetLayoutObjectAttribute( 'header', 'content' ) & GetLayoutObjectAttribute( 'row', 'content' ) & GetLayoutObjectAttribute( 'footer', 'content' ) ) works fine, the bad thing is that only row 1 finds its way to the output-field.
       
    • By hutchlad
      Hey Guys,
      Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue)
      My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
       

    • By Rachel
      This is my first time posting, and I apologize if this is the wrong place. I've only been filemakering for a few months, so again, apologies if this is a stupid problem.
      I could use some advice.   I'm working on a solution that must create monthly reports in the following form:   http://i.imgur.com/Cf4Fjic.png   I've given up trying to bend the summary fields to my will, and began using the following approach:   Make two new tables - Queries and Reports.   In queries table, I have fields for M1, M2, M3, Region, Category, Subcategory and four result fields (M1, M2, M3 and YTD.) I also have foreign key into the reports table.   Then in reports table, I portal into the Queries table.   When report is run, a bunch of queries in queries table are created. The Results are populated via ExecuteSQL expressions.   My question is mainly this: Is this too backwards? I feel like maybe this is too weird of an approach and I"m just missing something simple about reporting and creating summaries?

      Thanks!  
  • Who Viewed the Topic

    3 members have viewed this topic:
    marioantonini  THABALI  NewBoard 

×
×
  • Create New...

Important Information

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