Set Analysis Query

[#1]

Good Day, I have the following expression that I would like to convert to Set Analysis:

=Sum(If([Field1] = 'Value1',
IF([Field2] = 'Value2',
IF( [Field3]>0, [Field4]))))

What I have so far is this:

=Sum({$<[Field1] ={'Value1'},
"=Sum({ $ <[Field2] = {'Value2'}>}
[Field3]) >0"> }[Field4])

but it does not give me the desired result.  Anybody know where I'm going wrong?

[johnw · Accepted solution]

I believe this (and be sure to note single vs. double quotes - single indicates a literal, double indicates a search string):

sum({<Field1={'Value1},Field2={'Value2'},Field3={">0"}>} Field4)

[#3]

Hi John, thank you very much, that did the trick. Also thank you very much for the tip.