Summarize custom fields incrementally not working as planned
Posted: Tue Jul 31, 2018 3:46 pm
I need to calculate the average area of active in Samples A and B and multiply this by a factor in CConst1. 3 injections each of Sample A and B and the custom field formula is A.%..AVE(Area)*CConst1 and B.%..AVE(Area)*CConst1. So my sample set sequence is: Diluent, Sample A, Sample B of Batch #1 then Sample A and Sample B of Batch #2 etc so i put in the function "Summarize Custom Fields Incrementally" directly after my Sample B line then again after the next set of Sample A/B.
But its not giving me the right answer for any sets AFTER the first one. The first one works fine but any sets after that Empower is taking the average area of active in ALL A or B samples in the sample set and using that in the formula when i only want it to use the A/B average areas between each set, hence why i put in Summarize Custom Fields Incrementally between each set. Empower Help describes this function as summarizing all intersample summaries above the function and below the previous funtion, which means that Empower doesnt really "see" any samples above this. I do have the runs in Run Only mode and all processing set to normal, does that make a difference?
Can anyone help with this?
But its not giving me the right answer for any sets AFTER the first one. The first one works fine but any sets after that Empower is taking the average area of active in ALL A or B samples in the sample set and using that in the formula when i only want it to use the A/B average areas between each set, hence why i put in Summarize Custom Fields Incrementally between each set. Empower Help describes this function as summarizing all intersample summaries above the function and below the previous funtion, which means that Empower doesnt really "see" any samples above this. I do have the runs in Run Only mode and all processing set to normal, does that make a difference?
Can anyone help with this?