Calculating Sum for Certain Dates

[Delights]

Greetings;

I was using the formular

"Sum(Shows)" to sum the total of shows,

However i was wondering if there was a way to make it so that it would count the amount of shows for the calandar month before.

[Søren Dyhr]

Since you're fm9 must either a genuine subsummary report be the best bet:

....or Ugo's method if live figures needs to be obtained without leaving browsemode:

http://fmforums.com/forum/showtopic.php?tid/189946/post/266469/hl/clayfeet/fromsearch/1/#266469

If however it isn't lethal in your case to facilitate a layout with a button to obtain the reporting could the first mentioned approach be turned into this:

http://www.kevinfrank.com/download/kf-fast-summary.zip

But if you shouldn't have you profile absolutely in sync with reality, and actually use fm10 allready, the watch this:

http://www.youtube.com/watch?v=OqI2TA4kVZU

--sd

[Matthew F]

To be more specific about using calculations in browse mode...

Assuming you have primary data fields:

ShowDate

ShowID

Then define some calculated fields:

ShowMonth = Month(ShowDate)

ShowYear = Year(ShowDate)

Create a report layout with fields:

LastMonth = Month ( Get(CurrentDate)) - 1

Year = Year ( Get(CurrentYear)

Define a relationship to your report layout and your primary data table:

Report::Year = Data::Year AND Report::LastMonth = Data::Month

The sum of the shows would be defined on the Report layout as:

Count(Data::ShowID)

Cheers,

[Søren Dyhr]

While this used to be my way of replying ....mfero, couldn't anything particular be said about the scale of the data to be munged - To be honest doesn't it take much effort to turn a otherwise healty layout slow as molasses, if a craving thirst for such really existed - your method could one way of attempting such. But sub summaries are designed to scale while aggregates not really are:

http://fmforums.com/forum/showpost.php?post/313019/

--sd

[Søren Dyhr]

Date ( Month ( theDate ) ; 1 ; Year ( theDate ) )

theDate-Day(theDate)+1

....seems faster to me? Only I can't find a way to prove it reliable!

--sd

[Matthew F]

Good point!