Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
Hi John, thank you very much, that did the trick. Also thank you very much for the tip.