Exclude fields in the calculation?

[Mynona]

How do I create an expression similar to the following?

sum({<Field1={Test1}, [Field2]<>[Field3]>} [Field4])) 

Field4 should be displayed if Field2 and Field3 are not equal. If I create an expression as above, I get an error because <> is not a valid relational operator.

How do I create this correctly?

[F_B]

Hi @Mynona , try with =- instead of <>.

[MatheusC]

@Mynona 

see it like this:

sum({<Field1={Test1}>}if ([Field2] <> [Field3],  [Field4]))

Regarts, Matheus

[Chanty4u]

Try this 

aggr(

    if(Field2 <> Field3, sum(Field4)),

    Field1, Field2, Field3)