3 Replies Latest reply: Nov 1, 2013 8:24 AM by Prem Kumar Thangallapally RSS

    IF expression with z-analysis

    Jon Einebærolm

      Hi all,

       

      I'm trying to develop an if expression including z-analysis.

       

      I have three fields in "Club" that I want to conditionally show. When Month=jan, feb, march and april

      I want to exclude business case 2 and business case 3. When Month=May, Jun,July and august I want to exclude Business case 1 and business case 2. When Month=Sep, Oct, Nov and December I want to exclude business case 1 and 2.

       

      I have made the below expression that is not working, not sure why.

       

      sum(if(Month='jan',Sum({$<Measure={'Month Development Members'}, Club-={'Business Case 1'} >}))Value)