cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles