Can you merge the 2 set analysis expressions?

[aaronnayan]

Hi Guys

Can you merge these two expressions if possible?

Into 1 expression

sum({$<ADVISORS={"JAMES"}>}SALES)     +          Sum({1<DEC_Month={'$(vCurrMth)'}>}SALES)

[tresesco]

If you want to get the sum of them using one expression, try like:

using OR logic:

sum({$<ADVISORS={"JAMES"}> + <DEC_Month={'$(vCurrMth)'}>}SALES)

if you want both the condition to be true, try like:

using AND logic:

sum({$<ADVISORS={"JAMES"} , DEC_Month={'$(vCurrMth)'}>}SALES)

[aaronnayan]

Hi TResesco

Its not picking up the variable. I want it to calculate it using for the current month

Could you help?

[tresesco]

If variable is an issue, try like:

DEC_Month={'$(=Month(Today()))'}

If the month format of your field matches with the format return by the expression, it should work.