Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Can you merge these two expressions if possible?
Into 1 expression
sum({$<ADVISORS={"JAMES"}>}SALES) + Sum({1<DEC_Month={'$(vCurrMth)'}>}SALES)
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)
Hi TResesco
Its not picking up the variable. I want it to calculate it using for the current month
Could you help?
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.