Evaluate Multiple set analysis expression in one equation

[#1]

Perhaps I am just missing the syntax or my (Join together) expression is wrong.  I would like to take first and second and join them together into one expression.  Is this the correct way to do this because it does not appear to be working?  How do you join both of these together?  Probably simplier than I am thinking...

//First
sum({$<SaleRepCustom_ID = {2} >} JonesHouse50_Sales) 
//Second
sum({$<YearFiscal={$(=max(year(YearFiscal))-1)}>} JonesHouse50_Sales) 
//Join together
sum({$<YearFiscal={$(=max(year(YearFiscal))-1)}>} {$<SaleRepCustom_ID = {2} >} JonesHouse50_Sales) 

Thanks for any assitance.

[#2 · Accepted solution]

Jake,

Assuming your individual expressions are working fine, this should give you the result:

=sum({$<SaleRepCustom_ID = {2},YearFiscal={$(=max(year(YearFiscal))-1)}>} JonesHouse50_Sales)

Conditions in set analysis can be seperated by a comma (as above).

Hope that helps,

Regards,

-Khaled.