Hello,
Can we bypass same field which we are using in aggregate function. I wanted to ignore HQ filter while calculating Contribution, Please check my expression
=Sum(total {<HQ=>}
Aggr(
(($(vAch_MQY_PCPM)
/ Count(distinct {<[Division Name]={"$(vDivisionSelection)"},HQ=, I_Date={">=$(vCurrentYearStart)<=$(vCurrentDate)"}, CalendarYear=,T_Month, Period_INL=>} [MR Name]) )
/ $(vPCPM_Month)
)
Here,
$(vAch_MQY_PCPM)=
Num(Sum({< DataType={'Value_Ach'}, I_Date={">=$(vCurrentYearStart)<=$(vCurrentDate)"},HQ=,, [Division Name]={"$(vDivisionSelection)"},CalendarYear,T_Month>}Data), $(vCurrancy))
