Hi
In the below aggregation which works well I also want to add only 'NEW' products (TYPE = "NEW').
Could someone tell me how would I include also TYPE = 'NEW' in the below aggregation so that it only sums up 'NEW'
=-
sum(aggr(distinct only(INFPERIOD)='$(vInforceMonth0)',Value))
Thank you!