Calculation to compare percentage increase/decrease across records

[lizzie]

Greetings

I have generated a sub-summary report which looks at each employees sales per month. I want to be able to calculate the percentage increase or decrease in sales from month to month, and from year to year.

This is easily achieved in Excel.

How would one perform this calculation in FM?

[Søren Dyhr]

I think it needs to get scripted, via an extract of this algorithm:

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

--sd

[comment]

I think it needs to get scripted

Not necessarily - but it turns out to be quite a challenge, not something I would recommend to a beginner.

CompareSubsummaries.fp7.zip

[Søren Dyhr]

It was something in the same direction I thought about as well, where I perhaps would have stored the previous "quater's" GetSummary( in a variable before going to the next via scripting on the found set.

But your's have an advantage that it's multiuser friendly, where mine in worst case would allow users to overwrite each others calcualtions.

--sd