7 Replies Latest reply: Dec 10, 2014 2:06 PM by Nate Brunner RSS

    Conditional dimension

      Hi,

       

      I have a bar chart which shows active contract for the 6 previous months. The thing is there are fictitious end dates for some of the active contracts causing one of the months to be for the year 2099. These contracts still need to be counted, but should be grouped with the current month instead of June 2099.

       

      This is what I have in my load script to create my dimension:

       

       

      AddMonths(MonthStart(StartDate),iterno()-1) as ContractMonth

      While MonthStart(EndDate) >= AddMonths(MonthStart(StartDate),iterno()-1);

       

       

      And this is my expression:

       

      Count({<Company = {'24'}, Status = {A}>} CustomerNo)

       

       

      Any help is welcome!