Conditional Summary Custom field not working for Average
I want to calculate the average area of a number of injections, these injections can differ depending on batch and conditions from one run to the next. I set up a Sample Text CF called CF_Ref and I want only injections where CF_Ref = Ref1 to be considered so my second Peak, Real CF (result set only) becomes:
The above will consider all labels, all injections and separate channels where only CF_Ref = Ref1. Weird thing is, it works fine for MAX, MIN and SUM area but when I try AVE, I get a really low result which is obviously not the average area. My tablespace is fine, so I don't know what else it could be. The only processing codes I get is SC02 and SC30 which relate to "summary custom calculation error" which isn't very helpful.