Cant get a sample custom field to work
I created 2 Sample, Real CFs width 12 precision 6 called Value_One and Value_Two. I enter values in the sample set for example 45.8977 in Value_One and 12.0901 in Value_Two and then I created a third CF Sample Real Calculated (again Width of 12 precision of 6) called Difference. I want the values for Difference to be the same as the value in Sampleweight so I coded a Sample Bool CF as EQ(Sampleweight,Difference) and the translations as Yes and No.
But for some odd reason, only about 1/3 of my values are showing up as Yes even when the values for Difference and Sampleweight are the exact same. I cant see whats different between these values. Oddly when I throw in clean values like 20 and 10 and the difference is 10, then this always equates to Yes when I put 10 in the Sampelweight but my values aren't clean and are typically 58 to 68 to 4 decimal places, so 58.9087 or 66.0091 etc. I cant understand why, when the values are the same, its not translating to Yes. I tried changing the name of the CF and the order so EQ(Difference, Samplweight) but nothing seems to be changing the random nature of the Yes or No...
Anyone any insight into this please?