3 Replies Latest reply: Oct 17, 2013 9:27 AM by SS SS RSS

    Replacement IF condition by set analysis

    SS SS

      I got an expression with IF condition. It work's too slow. I want to change it to set analysis,

      1. Expression with IF (it works fine):

      sum(aggr( count (DISTINCT  if([Month] = [DistMonth],

        [CholdingID])),Fil, [MY],[CholdingID]))


      2. My expression:


      {1<[Month] = {"=[Month]=[DistMonth]"}>}



      The main trouble is in marking multiply values in [DistMonth]. When i use first expression everything works fine. But with second expression I cant chose  multiply values. Second expression works with single value of [DistMonth] only. When i try to get two values of [DistMonth] it dont show me two values in dimension.