3 Replies Latest reply on Oct 26, 2009 2:53 PM by philmodjunk

# Calculations for average stock turnover in a month

### Title

Calculations for average stock turnover in a month

### Post

Dear all,

I am a newbie in filemaker and I have question about calculation for average stock turnover in a month.

There are two field :

Datefield (contains the month, date, year when the stock was input)

InputQty (contains quantity of stock added)

Would you mind helping me to get the calculations for this.

• ###### 1. Re: Calculations for average stock turnover in a month
Does "stock turn over in a month" represent the total change in number of shares in a month or the total number of shares bought or sold in a month? Or  something else?
• ###### 2. Re: Calculations for average stock turnover in a month

I also have another field called OutputQty (Number of stock being sold).  I actually need two calculations which are

total number of stock bought in a month (InputQty) and total number of stock sold in a month (OutputQty).

• ###### 3. Re: Calculations for average stock turnover in a month

Presumably, you have a date field in the record that records the date the stocks were bought or sold. Let's call it TransDate for this example.

Let's create a calculation field that marks all records with the same value if the TransDate value falls in the same month. Call it cMonth and set it to return "Date" as it's return type.

Date ( Month(TransDate), 1 , Year(TransDate) )

Now you have two options:

Option1: create a summary report.

Define a pair of Summary fields sTotalOutputQty (Total of OutputQty) and sTotalInputQty (Total of InputQty).

On a list view layout based on this table, create a sub summary when sorted by cMonth and place these fields in that sub-summary part. From here, you have a lot of options depending on what you want to see on your report. You can create a second sub-summary part when sorted by stock ID to cluster stocks by stock ID. In either case, to see the results you want, use a find to pull up the records you want, then sort them by the fields you specified as "sort by" in the sub-summary part set up.

Option 2: Create a calculation field that returns the monthly sub-total whenever the records are sorted by "cMonth".

Get Summary ( sTotalOutputQty; cMonth )

Get Summary ( stotalInputQty; cMonth )