2 Replies Latest reply: Oct 14, 2013 11:22 AM by Gysbert Wassenaar RSS

    aggr should not include month

      Hello,

       

      I have this aggr expression:

      SUM(
      { <
      Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}
      aggr(
       
      SUM(
        { <
      Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"}, "[DimTimeType].TimeTypeName" = {"ExternalBillableTime"} > }
       
      "[FactQVTimeRegistered].TimeRegistered"
        )
        ,
      "[DimOrganization].Name"
        ,
      DateKey
      )
      )

      This expression DOES NOT include month - Which is correct:


      However i have this expression:

      /
      SUM(
      { <
      Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}
      aggr(
        7.5 *
       
      "[DimOrganization].FTE Factor" *
        (
       
      Count(
        {<
      Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"}, "IsWeekend" = {'0'}, "[DimBankHolidays].BankHoliday" = {'0'}, DateKey = {'<=$(=vTodayDate)'}  >}
       
      distinct DateKey
        )
        -
       
      sum(
        {<
      Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}
       
      "[Vacation2].Days"
        )
        )
        ,
      "[DimOrganization].Name"
        ,
      DateKey
      )
      )


      And this Expression Includes month BUT IT SHOULD NOT - What is wrong with it??