• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About laguna92651

  • Rank

Profile Information

  • Gender

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Windows 10
  • Skill Level

Recent Profile Visitors

1,835 profile views
  1. I am working on putting a line chart on top of a scatter chart, I select transparency of the line chart background and it does not become transparent, is there something else I should be doing. I am using FM14. The scatter chart will not become transparent either.
  2. Got the scatter charts I wanted using multiple tables and return delimited data (using List function). What would be the best way to filter the financial data in the scatter chart by year and/or company? Show only certain companies, hide/show a data series. Show only data for certain years.
  3. Can you point me to some examples of doing this, thanks.
  4. Thanks, I'll review the Filemaker Hacks article.
  5. I would want each company series for; Year 1, Year 2, Year 3, to be a different color, so if I used one table I would need 6 sets of Sales (Sales 1, Sales 2, Sales 3...), 6 sets of Net Income etc. to have control of he series markers, correct?
  6. I am capturing financial information for 5 companies (probably not more than 5 companies would be needed), that are related to each account in the database. Each account in the database would have a different 5 companies associated with it. I want to graph specific data of all 5 companies and the account on a single scatter chart. I am having problems getting the chart to show more than one companies set of data. I currently have a table for each of the 5 companies, would I be better off to have all of the financial data in one table? If I went with separate tables for each company, what is the best approach to create the scatter graph showing the 5 companies plus the account on the chart? Example of data to be entered, AT and ROS are the elements to be charted.
  7. Actually I liked the "leading sub-summary by Category" look better, thanks for the input. Thanks again.
  8. Worked great, thank you.
  9. I have a layout in list view, the number of entries after the first entry will vary, current layout. How would I go about only showing the first occurrence of an entry under Category, the entries under Item and Sub-Category would remain the the same, desired format. II Capital Hardware (blank) Peripherals (blank) Network (blank) Application Software etc. III Project Expenses Strategic Planning (blank) Consulting: Network (blank) Consulting: Process etc.
  10. Is it possible to chart the following data shown in this sub-summary report. The data is all in one table called financials. I would like to chart the data as though there were three series, one for each company. Is this possible to do? I would prefer a standalone chart but could use in a sub-summary report. The y-axis is the ROS data and the x-axis is the AU data.
  11. I've seen some of the Virtual List articles in the past, this will be a good reason to go through this series, thanks.
  12. I would like to replicate this Excel cash flow statement in Filemaker. Looking for some ideas on how to go about this. I may be making this more complicated than it needs to be. Should I place multiple portals in a list view form or is this all doable with a sub-summary report? The line items would not necessarily be the same for every account, in some cases there would be less or more items. Ideally I would like to collapse the various sections.
  13. Thanks, the mod calculation worked great.
  14. I am creating a yearly contact schedule for each account, lets say visit each account every 3 weeks. So all visits don't happen on the same weeks, I'm staggering the start week for each visit sequence, so account 1 starts this week, account 2 next week, account 3 in 3 weeks, account 4 in 4 weeks, then start over, account 5 this week. I'm open to other ways of doing it.
  15. I have a found set of accounts, for each account I am creating a set of records starting at the current date with each additional child record's date field incrementing by 8 days. The two loops are working fine. Date Records 7/1/2016 7/9/2016 7/17/2016 7/25/2016 8/2/2016 etc. I would like to stagger the start dates into 4 groups 1st Account's record sequence starts today. 2nd Account'srecord sequence starts 7 days later. 3rd Account'srecord sequence starts 14 days later. 4th Account'srecord sequence starts 28 days later. 5th Account'srecord sequence starts today. 6th Account'srecord sequence starts 7 days later. 7th Account'srecord sequence starts 14 days later. 8th Account'srecord sequence starts 28 days later. 9th Account'srecord sequence starts today. 10th Account'srecord sequence starts 7 days later. 11th Account'srecord sequence starts 14 days later. 12th Account'srecord sequence starts 28 days later. ... and so on. New Account 1 Date Records (the same) 7/1/2016 7/9/2016 7/17/2016 7/25/2016 8/2/2016 etc. New Account 2 Date Records (starts 7 days later) 7/8/2016 7/16/2016 7/24/2016 8/1/2016 8/9/2016 etc. What would be the structure to set the date field to the correct staggered date for the account records as I loop through the account found set.