Help how I need a expression

[Soufiane_M]

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I do SUMIF() or SUMIFS()? SUM( SELECT( Orders[Total Amount], AND( ([Customer] = [_THISROW].[Customer]), ([Order Date] >= [_THISROW].[Order Date]) ) ) ) Use SELECT() to gather values from a single column only. See also: AND(), SUM()

[Soufiane_M]

Still not understand ??

[LeventK · Accepted solution]

@Soufiane_M
Your question is already replied here! Is there a need to create the same post again and again?
https://community.appsheet.com/t/question-about-sumif/36643/3

[Soufiane_M]

It doesnt work neither
SUM( SELECT( vente[total], [facture-id]=[_THISROW].[id] ) )
Nor SUM( SELECT( vente[total], [facture-id]=[_THISROW].[facture-id] ) ).
I am sorry about the two topics , i tought that the first one is deleted … And the are not the same

[LeventK]

@Soufiane_M
Neither your post nor your explanation or description of the problem is clear, even a bit vague. You have given a screenshot of 2 tables’ column structures. I can quickly raise below questions:

• how can we predict which table the ref column ([facture_id]) in vente table is referring to?
• In facture table you have a facturesomething column where the details can’t be read because of the covered text
• You have stated the problem with the sentence: “Sum of vente[Total] if vente[facture-id] is same” > …is same as per which value? which column? which table? which reference??
• Do you have any initial value or appformula in vente table [Total] column? If so, what’s the expression?
• Have you tested anyone of the proposed expressions or anyone of your own expressions in the Expression Builder? All have returned a blank value?
• Under which table are you trying to construct this SUM() expression?

Would you like to clarify the above questions or are you expecting from us to put up our magic sphere on the table? Thanks.

[Soufiane_M]

Thank you very much , it works nice only with a virtual column
SUM( SELECT( vente[total], [facture-id]=[_THISROW].[id] ) )