my equation not equal dont work, but when i try egual, it is workink

[Gnak]

Hello, I have a formula that does not work. I would like to have the addition of my related products transactions when state_transaction does not equal Delete. When I try the opposite, it works, but not the other way around. thank you for helping me

The formula in ma column qte_not_delete:

SUM(SELECT([Related produits_transactions][qte],[id].[etat_transaction]<>"Delete"))

  

[Denny774]

Hey,

here it is 😉

SUM(SELECT(produits_transactions[qte], AND([id] = [_THISROW].[id], [etat_transaction]<>"Delete")))

[AleksiAlkio · Accepted solution]

Does it work with? 
SUM(SELECT([Related produits_transactions][qte],[etat_transaction]<>"Delete"))