Set Analysis Modifier is working for only 1 expression

[Anonymous]

Hi All,

I am using below expression for set analysis. By default it should show sum of Active count for both the sources('abc' and 'xyz') but it is working only for 'xyz' source and not for 'abc' . However when I select abc or xyz from list box it works perfectly.

sum({< activeinactivedate2= {'$(=max(activeinactivedate2))'},FinYearID= {'$(=max(FinYearID))'},Source = {'abc'}>} Active)+

sum({< activeinactivedate= {'$(=max(activeinactivedate))'},FinYearID= {'$(=max(FinYearID))'},Source = {'xyz'}>} Active)

I don't think so that there is issue in logic because it shows exact count after selecting the source from list box.

Please let me know where I am wrong.

Thanks

[vishsaggi]

May be this:

= RangeSum( sum({< activeinactivedate2= {"=$(= Date(max(activeinactivedate2), 'MM/DD/YYYY'))'}, FinYearID= { "= $(=max(FinYearID)) "}, Source = {'abc'} >} Active), 

sum({< activeinactivedate= { "=$(= Date(max(activeinactivedate), 'MM/DD/YYYY'))"}, FinYearID= {"= $(=max(FinYearID)) "}, Source = {'xyz'} >}  Active) )