Summarize Custom Fields Incrementally issue
I am trying to use Summarize Custom Fields Incrementally twice across one sample set and I cant get the results im looking for.
Here is what I need:
(Average Area of Sample A – Average Area of Sample *100 which is a custom field I have set up circa ABS((A.%..AVE(Area)-B.%..AVE(Area))*100
Then another set of samples
With the same formula required. I put in “Summarize Custom Fields Incrementally” directly after my first Sample B then again directly after my second Sample B but although I get correct results for the first Set of Samples, when it comes to the second set, Empower is taking the average area of my active across BOTH sets of A and B instead of just the one set. I thought by putting the Incremental function where I did, it would “block” Empower from seeing any samples above that function line and only consider the samples between one Incremental function and another. When I checked the Empower Help on this function, that’s what I understood that it meant: “Summarize Custom Fields Incrementally – add one or more functions in a sample set to calculate incremental summary results using all samples above its function row that match the custom field syntax. Each function stores its summary value for only those samples above its row and below the previous function row.
But it doesn’t seem to have done that for my dilemma, it’s still averaging active areas from the first samples when calculating the second set of A/B samples. Any ideas what im doing wrong or is this even possible? I attach a shot of how I set up this sample set..