Comment supprimer des valeurs

hcarr01

Bonjour, pourquoi les valeurs sélectionnées sur la BD ne sont pas manquates (« . ») ?

 

Cordialement

txnelson

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
)