Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]) |
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])
what is the variable?
can you share the expression within the Variable
(sum( {<NOTE = {'100'}>}[ACTUAL] )*-1)
this is my expression for variable
it wont work, why not create a variable for the whole thing
EOnlyYearNetProfit
sum( {<NOTE = {'100'},YEAR = {"$(=Only([YEAR]))"} >}[ACTUAL] )*-1)
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).
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])