How to combine set analysis with an if function

[Anonymous]

Hi

I have the following expression

sum(aggr(sum(if(Door1 + Door2 = 1 , Door3)), Outlet))

I want to incorporate the set analysis , {< [FA Group], SKU, Year = {$(vMaxYear)} >}  into the expression, 

How i do i this?

Thanking you in advance.

Kind regards

Nayan

[sunilkumarqv · Accepted solution]

hi Nayan,

Please try this

sum({< [FA Group], SKU, Year = {$(vMaxYear)} >} aggr(sum({< [FA Group], SKU, Year = {$(vMaxYear)} >} if(Door1

+ Door2 = 1 , Door3)), Outlet))

[Anonymous]

Thank you Sunil.  It worked.

Kind regards

Nayan