GetFieldSelections set analysis

[#1]

Hi everyone,

I want to have an expression that sums all amounts where Field2 DOES NOT equal the current selection in Field1.

E.g. If A was currently selected, I would not want the first row included in the sum.

	Field2	Amounts
	A	10
	B	5
	C	2

Does anyone know how to write the set analysis for this? I'm still struggling to learn.

Thanks!

[rubenmarin · Accepted solution]

Hi Andrew, you can use this expression:

Sum({<Field2=Field2-Field1>} Amounts)

[Clever_Anjos]

Check for function P()

=Sum({<Field2-=P(Field2 )>} Amounts)

[#4]

Thank you both!