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

    Replacement IF condition by set analysis

    Stanislav Strogiy

      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:

      count(Aggr(sum(

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

      1),Fil,[Month],[CholdingID]))

       

      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.