Set analysis check for equality between fields

[#1]

Hello,

I am trying to check for field1 = field2 and compute sum(filed3) in set analysis expression.

Ex:

   Field1   Field2   Field3

    01          01         1

    02          01         1

    02          02         1

    02          02         1

if, '01' of Field1 is selected, then the result shoud be  1,

if '02' of Field2 is selecetd, then the result shuld be 2.

Please help me

Thanks,

Deepa

[alexandros17]

In set analysis you cannot compare a field with another field but only a field with a value (this can be the max, sum, aggr ... of another field but not the whole field)

Hope it helps

[#3]

You mean, we cannot compare the value of Fieid1 with value of Fields2

as we do in IF(Field1 = Field2,Sum(Field3))