Jump to content
Sign in to follow this  
MitchBVI

Problem with Repeating Fields

Recommended Posts

I am trying to extract data so I can summarize it by months and also by years. I have created two fields one for months the other for years the first works and the second does not.

This is the definition of both fields can anyone see what I am doing incorrectly please.

MonthsWellsTran =Case(Get(calculationRepetitionNumber)=Month(Extend(TDate));Extend(Revenue). This has 12 repitions for the months.

Figured this out it was the case test that was incorrect.

YearsWellsTran

=Case(Get(calculationRepetitionNumber)=Year(Extend(TDate));Extend(Revenue).This has7 repetitions as so far only have data for seven years.

The month one works fine but for some reason the yearly one does not return any results at all.

Any help greatly appreciated.

Thanks

Mitch

Edited by Guest

Share this post


Link to post
Share on other sites

If I understand your explanation correctly, the YearsWellsTran field would work well if your data came from years 0001 - 0007.

However, this not a good method overall. What will you do when the data spans 8 years, or more? Usually it's better to produce a report, sub-summarized by year and month.

Share this post


Link to post
Share on other sites

Thanks for that it was my case test that was incorrect. Just added 2000 to the repetition number and it works 2001 through 2008. You are correct of course when data is past this year I will have to increase the number of repetitions. Works but crude I know any suggestions appreciated.

Mitch

Share this post


Link to post
Share on other sites

It will work quite well with months, because there are always 12 of them. With years... any method you choose, you will encounter the same problem of Filemaker being limited in the horizontal direction.

Still, you might want to also take a look at this:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    Veselko  nexgen 
×
×
  • Create New...

Important Information

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