Jump to content

laguna92651

Members
  • Content count

    138
  • Joined

  • Last visited

Community Reputation

0 Neutral

About laguna92651

  • Rank
    member

Profile Information

  • Gender

Recent Profile Visitors

1,884 profile views
  1. Charting Transparency Problem

    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. Charting Multiple Tables On Scatter Graph

    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. Charting Multiple Tables On Scatter Graph

    Can you point me to some examples of doing this, thanks.
  4. Charting Multiple Tables On Scatter Graph

    Thanks, I'll review the Filemaker Hacks article.
  5. Charting Multiple Tables On Scatter Graph

    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. Blanking Entries After First In List View Report

    Actually I liked the "leading sub-summary by Category" look better, thanks for the input. Thanks again.
  8. Blanking Entries After First In List View Report

    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. Chart series by sub series

    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. Generate multi section sub total form

    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. Generate multi section sub total form

    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. Staggered Start Dates

    Thanks, the mod calculation worked great.
  14. Staggered Start Dates

    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. Staggered Start Dates

    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.
×

Important Information

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