I'm new to PMF, so I'm hoping I'm missing something obvious.

I'm using a percentage aggregation to calculate employee turnover ([Terminations] / [Avg Monthly Headcount]), which works fine for each month. For the YTD calculation, PMF sums all of the terminations, which is good, but it also sums all of the monthly headcounts, which I don't want. I need the denominator to be an average of the monthly results rather than a sum. Is this possible?

Mike - Perhaps I'm misunderstanding your requirement, but it looks like this value will increase with each month.

Month   Turnover  Headcount   Avg Head Count    Turnover
-----   --------  ---------    -------------    -----------------
Jan            3        100              100       3 / 100 =  3.0%
Feb           10        110              105      13 / 105 = 12.4%
Mar            5        105              105      18 / 105 = 17.1%
etc
  

It this what you're looking for?

Correct. I need the total terminations in a given period divided by the average number of employees in that same period.

I have other measures with similar requirements (ex. Sum of sales in any period / Average days in the same period), so solving this will be a huge help!

Look up recomputed or summarize I think.

J.L., I'm pretty new to WebFOCUS. Do you mind elaborating on your comment?

If I'm understanding the question

TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
COMPUTE NEWVAR/D10.1%=(RETAIL_COST-DEALER_COST)/DEALER_COST*100;
BY COUNTRY
ON TABLE SUMMARIZE
END

Here's what I'm looking to accomplish:

Monthly Terms | Monthly Headcount | Monthly Turnover | YTD Turnover

17 | 583 | 2.9% | 2.9%
10 | 578 | 1.7% | 4.7%
18 | 578 | 3.1% | 7.8%
23 | 579 | 4.0% | 11.7%
20 | 578 | 3.5% | 15.2%
20 | 584 | 3.4% | 18.6%
23 | 593 | 3.9% | 22.5%
34 | 603 | 5.6% | 28.2%
22 | 611 | 3.6% | 31.8%
19 | 616 | 3.1% | 34.9%

The formula for monthly is simply (Monthly Terms) / (Monthly Headcount), which works fine. The formula for YTD Turnover is SUM(Monthly Terms) / AVERAGE(Monthly Headcount), which is where I'm having the problem. PMF doesn't give me the option to use an average, so when it calculates the YTD (or any other period of time), it adds all of the terms, which is good, but also adds all of the monthly headcounts, which is bad.

This is a standard HR measure, so I can't imaging that I'm the first person that has needed this. I have several measures that need the same concept with different denominators (ex. Avg Days per Month).

All that said, remember I'm a newbie to PMF, and I should also add that I don't have a coding background. For any type of coding like was suggested above, where do I even do this in PMF?

I appreciate any help I can get. The answer I got from IBI Tech Support was "I'm afraid it is not possible. I'm sorry we have no plan to implement this feature for now and it is not available." Given that these are common measures, I refuse to give up so easily!

Mike,
Thanks for sticking to it.
We're looking into this.

thanks

Hi Mike,
The only place for this to get done would be in the reporting core code in PMF because it is actually a different aggregation method - the denominator has to be averaged at reporting time, not when the data is loaded into the mart.

If we were to add this capability, it would mean you'd need to upgrade to the version of PMF that supported it.

PMF 8.1.1 is about to ship and won't have this.

The next release will be 8.1.2, sometime around the end of Jan/beginning of Feb 2016.

Would it work for you if we did it then?

Side benefit is you would get our new gorgeous dashboard system (coming out in 8.1.1) with that upgrade.

Let us know.

Waiting until February isn't ideal, but it's much better than not having the capability at all, and I look forward to seeing the new dashboards.

Thanks for looking into this, Bob.

Hi Mike,
Sometimes it takes time to make things that really work.
We got you on the next train.
If we can get it any sooner we'll let you know.

Thanks for being a great customer.