Ignore a Filter Selection in a Aggr Function with Set Analysis

Ask a Question

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

0 Replies