3 Replies Latest reply: May 11, 2017 6:29 AM by Marcus Sommer RSS

    IsNull in set analysis with variable

    Laura van der List

      Hi guys, I hope you can help me out with this one:

       

      I want to make a set analysis with a variable where Dim2 is null, but my code doesn't give me the correct results:

       

      sum(aggr(ONLY({<[Dim1]={'A', 'B', 'C', 'D'}, [Dim2] = {''} >}  aggr($(v_1), [Dim1], [Dim2])) / 1000, [Dim1], [Dim2]))