cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hcarr01
Level VI

Comment supprimer des valeurs

hcarr01_0-1679306895098.pnghcarr01_1-1679307012088.png

Bonjour, pourquoi les valeurs sélectionnées sur la BD ne sont pas manquates (« . ») ?
 
Cordialement
1 REPLY 1
txnelson
Super User

Re: Comment supprimer des valeurs

I suspect the issue is a precision issue with tth values displayed.  I suggest that you change the format of the E and D columns to display more than 4 decimal places.  This may expose where the issues are.  You may also be able to resolve the issue by rounding the values to 4 decimal places in your formula.  i.e

If(
	Abs(
		Round( :e[Sequence( 1, 55058, 1, 1 )], 4 )
		-Round( :e[Sequence( 2, 55058, 1, 1 )], 4 )
	) == Round( :d[Sequence( 1, 55058, 1, 1 )], 4 ),
	:f = .,
	:f = :e
)
Jim