Set analysis in set analysis

[Adrielmf2]

Morning.

Im trying to do a set analisys that has the same logic as:

If(sum(
{<
Year = {$(=year(today()))}
>}
Value2 >= 0,

sum(
{<
Year = {$(=year(today()))}
>}
Value1))

Can I do  this only with set analysis?

I was trying something like that, but doesnt work:

sum(
{<
Year = {$(=year(today()))},
Value2= {"=sum({<Year = {$(=year(today()))}>}Value2) > 0 "}
>}
Value1)

[marcus_sommer]

It's not possible to include such a condition within a classical set analysis. Even if you get the syntax right to have it within a set analysis statement it won't be executed as it else it's an if-loop. Therefore you should remain by you origin approach.

- Marcus