condition in set analysis

[#1]

I have two fields. I want to write expression where field 1 values equal to field2. like sum the amount where field1=field2.

I tried sum({<field1 ={"field1=field2"}>}Amount) but not working

[Kushal_Chawda · Accepted solution]

may be you missed '=', try

sum({<field1 ={"=field1=field2"}>}Amount)

[maxgro]

with field1 and field 2 as dimensions

sum(if(field1=field2, amount))

[sunny_talwar]

May be make the change in the script itself

LOAD field1,

          field2,

          If(field1 = field2, 1, 0) as Flag

FROM ...

and then use this:

Sum({<Flag = {1}>}Amount)

[#5]

Try this one

sum({<field1 ={'=field1=field2'}>}Amount)

sum(if(field1=field2,amount))

[#6]

Try this:

SUM(IF(Field1 = Field2, amount, 0))

Look for my QVW! !

[#7]

.