Statistics!

[JerrySalem]

OK geinuses,

I have a sales databse. Nothing fancy. List of stores, and Invoices, Lineitems. Invoices are generated basically weekly for each store.

But I want to do some statistics for inststance; -SLOPE-

What is the rate of change of the invoice total over the last month?

I want to be able to identifiy stores whose purchases are on the decline so I can call them to see what's up.

I seem to have hit a brain freeze on the subject. Any help appreciated.

Jerry

[trevorg]

Sounds like an export to Excel for some nice fancy smanshy reports with charts.

Or, create an ODBC link from Excel into FileMaker to generate the reports off of live data.

[kenneth2k1]

I fold...

All I know about slope is y=mx+b will give you a line, and there are lies, ******* lies and statistics.

Sorry

[trevorg]

Look at the "Trendline" function in Excel. If you can figure out which sales data to analyze, export it in CSV format, open it in Excel and apply the Trend Line, you will have what you are looking for.

[JerrySalem]

I like the excel idea, I may have to go there. But I am not excited about programming an excel template to calc trends for all 3,000 of our customers.

I am hoping for some sort of function or trick. In my wildest dreams I am looking for a func analagous to Sum(field). Maybe Trend(field1,field2)?

Without a better solution, looks like excel may win..Boooo.