variable

[upaliwije]

Hi Friends

I have created a variable and working fine when applied to a expression as follows

=($(vProfit))

but when I modify the expression like below it does not work.Will you please highlight   the error in expression please

=sum({$<YEAR = {"$(=Only([YEAR]))"},T_YEAR = {"$(=Only([YEAR]))"}>} $(vProfit))

[jpenuliar]

Agree with Lucian,

So if you can best describe what do you want to achieve with your Set Analysis, including which fields do you want to aggregate, and other filters you want to add in the expression.

[upaliwije]

THANKS

cNA YOU PLS HELP ME TO REWRITE THE EXPRESSION

[luciancotea]

=sum({$<YEAR = {"$(=Only([YEAR]))"},T_YEAR = {"$(=Only([YEAR]))"}>}  aggr( $(vProfit), YEAR , T_YEAR )  )

and I would replace all the expressions similar to

sum( {<NOTE = {'120','121','123'}>}[AMOUNT] )

with similar

sum( if(match(NOTE, '120','121','123'), [AMOUNT]) )