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
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
------------------------------
Here is the Report Formula I thought would work, but it obviously isn't.
([# of FT Separations]+[# of PTR Separations]+[# of PT Separations])/Average([# of FT], [# of PTR], [# of PT])
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
I guess it would depend on what you're trying to report on. I took a look at your charts and your comment about averages in the initial post which threw me off when the charges were totaling the turnover rates but I think I see what you're doing.
I'm just looking at the above of what you were trying to do now - and one issue would be that you're doing a total sum in the numerator but the average in the denominator. You can go either way but you should be consistent in either doing the totals for both or average for both and see how that looks. So either:
([# of FT Separations]+[# of PTR Separations]+[# of PT Separations])/([# of FT] + [# of PTR] + [# of PT])
or
Average([# of FT Separations],[# of PTR Separations],[# of PT Separations])/Average([# of FT] ,[# of PTR] ,[# of PT])
Depending on how your other values are being derived (either as a % or a number) you may have to multiply by 100 to bring it in line with the other values. It might be best to do the calculation and then list it in the table report to see how it looks - if your main ratios are all whole numbers where as the new one is a tiny decimal - you might just need to convert it from a percent so it reports properly.
------------------------------
Chayce Duncan
------------------------------