Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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