Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Hurlz

  • Rank
  1. Yes you are right it would. What you have done is perfect!! Thank you so much.
  2. Good question. As this is an overview document for senior management, I would envisage either a) divided into 3rds - one for each month of the quarter, or b) just the whole quarter coloured in.
  3. Hi there, I attach a sample database producing a Gantt chart for each day of the month supplied by directimpactsolutions.com Works brilliantly. However, I need to produce the same effect but for each calendar quarter (Q1 = Jan, Feb, March; Q2 = April, May, June; Q3 = July, Aug, Sept; Q4 = Oct, Nov, Dec). Can anyone advise on how to change this to produce something similar to the spreadsheet attached (used for display purposes only)? Thank you Gantt by Qtrs.xls Gantt Chart (unlocked).fmp12
  4. Thanks so much for that. All great except when I add the Div instead of Truncate as can be seen in the much simpler sample attached. The median values with Truncate for these 5 records are correct. with Div they aren't - what am I doing wrong? whitsunday_monitoring sample.fmp12
  5. thank you for that. I thought I had changed that for all calculations but had not. My apologies and sorry for not sending a simpler file too.
  6. Hi, in the attached database, we collect a range of readings per date. I need to calculate the median for each element (eg temperature, pH etc) across a range of dates. There is one record per date. The user will change the range of dates depending on what time period they want to view. The data doesn't need to be summarised by anything. I am most of the way there, thanks to this great post: https://www.briandunning.com/cf/298. I have run the script in that link on a field doing a summary list. However, the list doesn't seem to sort as specified in the script, and the median value re
  7. Ahhh, I see now. Thank you so much for a concise explanation. That makes sense and I was able to fix my issue. 😊
  8. Hi there, I am sure there is a really simple answer to this but I just can't crack it. I have two related tables: Property and AoPC. Each Property will belong in a particular AoPC. I have set up the relationship and a set of tabs on a layout in the AoPC table. Each tab has a portal showing particular properties in that AoPC depending on the value in another field in the Property table called Influence. The Portal Filter calculation is really simple: If(Property::Influence = "25m";"25m";""), with a different value for each portal. There are three possible values in the Influence fiel
  • Create New...

Important Information

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