Set analysis with Aggr

aarohipatel — Fri, 24 Jul 2020 16:04:30 GMT

Hello,

I am trying to implement an existing aggr expression with set analysis.

Sum(Aggr(If(Sum(ABC_field)=0,0,1),XYZ_field))

in this expression, I would like to add one more condition: Year= $(Year)

I have a variable for year.

Could you please advise on how to achieve these two in one set expression.

Thanks in advance

Re: Set analysis with Aggr

rubenmarin — Sat, 25 Jul 2020 09:05:54 GMT

Hi, can you try this?:

Sum({<Year={$(Year)}>} Aggr(If(Sum({<Year={$(Year)}>} ABC_field)=0,0,1),XYZ_field))