Excluding Peaks in custom field formulas
Can anyone clarify using Boolean functions in intersample custom fields? I'm trying to create a cf that will only populate in CCalRef1[Area} ie A.%.SAME(CCalRef1[Area]) and I don't want it populated for ANY other peaks in the chromatogram. When I tried this I got a value for the CCalref1 area fine but it was also populated for all other peaks. So I rewrote the formula as:
This put a 0 in all the other peaks when I wanted it blank so I activated All or Nothing and it worked, I presume because its an addition formula and will either produce a result if all conditions are present or none at all, therefore if the peak ISNT CCalref1 then all conditions aren't satisfied hence blank. If I didn't specify with the Boolean before and after the formula (ie all or nothing with just A.%.SAME(CCalref1[Area]) then I have the same issue with the value populated in ALL peaks,
When I changed it to a & before the NEQ part I got 0.00 for everything! I don't know why though, any ideas? Ive seen formulas in Waters slides such as LT(Area,Caffeine[Area])*((EQ(Area,CAffeine[Area])+NEQ(Area,Caffeine[Area])*-1*50000)) or similar but I couldn't get it to work for me.
Are Booleen variables in formulas really necessary and does it just take lots of practice to become accomplished in their use?