aggr should not include month

[#1]

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??

[bbi_mba_76]

Hi,

is "[DimOrganization].FTE Factor"  depending on Month field ?

Otherwise you could try to remove the count or sum to find where there is the error.

[Gysbert_Wassenaar]

If "[DimOrganization].FTE Factor" is a field then you have an implicit aggregation that does not exclude selections in the Month field. Try replacing it with something like: only({ < Month =, Year =, Week =, CMTD={'1'}, "[DimOrganization].Department" = {"Professional Services"} >}"[DimOrganization].FTE Factor")