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"))
โโ
Solved! Go to Solution.
Does it work with?
SUM(SELECT([Related produits_transactions][qte],[etat_transaction]<>"Delete"))
Hey,
here it is ๐
SUM(SELECT(produits_transactions[qte], AND([id] = [_THISROW].[id], [etat_transaction]<>"Delete")))
Does it work with?
SUM(SELECT([Related produits_transactions][qte],[etat_transaction]<>"Delete"))
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |