How to make this If as a Set?

[#1]

Hi

I´m trying do change this If expression to a set expression but can´t make it to work. Can someone help me?

If(A3 = 653, sum(Utfall_Belopp * _Flagga_Drift * _Flagga_TransUtbetald),
if(A3 = 651 and Konto = 7921 or A3 = 651 and Konto = 8597 or A3 = 651 and Konto = 7931, sum(Utfall_Belopp * _Flagga_Drift * _Flagga_TransUtbetald)))

[#2 · Accepted solution]

Try with:

Sum({<A3 ={653}>+<A3 ={651}, Konto={7921}>+<A3 ={651}, Konto={8597}>+<A3 ={651}, Konto={7931}>}Utfall_Belopp * _Flagga_Drift * _Flagga_TransUtbetald)

[#3]

Thanks! Did't know about the >+< operator. Nice to learn new things!

[#4]

Yes, the + operator stands for union of both sets of records(rows that belong to any of the unioned sets). There also is:

- for Exclusion

* for Intersection

/ for Symmetric Difference

Take a look: