variable

[upaliwije]

I have created the following expression using ENetProfit as a variable. But It is not working. Pls help me to trace where I have gone wrong

SUM( {$<YEAR = {"$(=Only([YEAR]))"}>} [ENetProfit])

[rustyfishbones]

what is the variable?

can you share the expression within the Variable

[upaliwije]

(sum( {<NOTE = {'100'}>}[ACTUAL] )*-1)

this is my expression for variable

[rustyfishbones]

it wont work, why not create a variable for the whole thing

EOnlyYearNetProfit

sum( {<NOTE = {'100'},YEAR = {"$(=Only([YEAR]))"} >}[ACTUAL] )*-1)

[Anonymous]

You should save only the set expression that is enclosed in the angle brackets "<>" into a variable.  So vNetProfit should be

vNetProfit =            NOTE = {'100'}

So your base equation would be eNetProfit = SUM({$<$(vNetProfit)>}[ACTUAL]*-1).

When you expand upon it then it would look like this.

eNetProfittByYearOnly = SUM({$<$(vNetProfit),YEAR = {"$(=Only([YEAR]))"}>}[ACTUAL]*-1).

[brijesh1991 · Accepted solution]

if your year is fiscal year i.e 2013-14, then

SUM( {$<YEAR = {'$(=Only(YEAR))'}>} [ENetProfit])

if your year is normal year i.e 2014, then

SUM( {$<YEAR = {'$(=Max(YEAR))'}>} [ENetProfit])