Summary Formula?
Not sure if that's what I need to be doing. See the table below. I want to show Total Turnover Rate (not a field in my table), in addition to FT, PT and PTR turnover rate. I was thinking that was ...
Forum Discussion
It looks like you already have it by month in this table. Can you have an Employee Type Table that uses this table as a child. Then you can Roll up the totals and use a formula field to do the math.
------------------------------
Tammie King
------------------------------
Tony - can you explain what you're trying to do that you're not able to get to work? This isn't a summary report, so if you're trying to calculate the rates based on the fields in this table then it's just your run of the mill formula field. If you're goal is to actually create a summary report that rolls these up by month - you can make a summary report so that you can at see the month as one line - and in there you can do a summary formula, or realistically since you only seem to have one row per employee type per month as is, you could just create the formula field on the row and just sum it in the summary report since a PTR record wouldn't have any FT values to do math for and would be adding 0 to your summary column.
------------------------------
Chayce Duncan
------------------------------