Set Analysis variance between 2 fields

[alan_grn]

I am trying to write set analysis for the following :

Sum Sales where Field1 > 0, Field2 > 0 and Field1- Field<0

I can get the first 2 pieces to work but when I try Field1-Field2={'<0'} I get no values

[Anonymous]

You can try Field1 ={"<$(Field2)"}, that is the same of Field1-Field2<0

[alan_grn]

Thanks

Field1 ={"<$(Field2)"},

but I also need where Field1 > 0.

Sum({< Field1 ={">0"},Field2={">0"},Field1 ={">$(Field2)"}  >} Sales)

My code above works but I think that this give me where Field1 > 0 or > field2. How do I change this to and?

I need where Field1 > 0 and field1 >Field2

[Anonymous]

You can use intersection "*", for example:

Sum({< Field1 ={">0"}, Field2 ={">0"}>*<Field2 ={">0"},Field1 ={">$(Field2)"}>} Sales)

or something like this..