Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
While calculating the Revenue for Current and Last fiscal year:
Variable is being used are as follows:
Variables result has been tested by pasting them in charts > KPI.
Master Items Created with Expressions as follows:
* Variables in the Master Items: RevCurrentYear & RevLastYear are not working, can somebody please help
Can you try one of these:
Sum({<FiscalYear = {'$(=$(CurrentYear))'}>}RowTotal)
Sum({<FiscalYear = {'$(=(LastYear))'}>}RowTotal)
or
Sum({<FiscalYear = {'$(=CurrentYear)'}>}RowTotal)
Sum({<FiscalYear = {'$(=LastYear)'}>}RowTotal)
Hi,
This is just off the top of my head but try:
Sum({<FiscalYear = {"=$(CurrentYear)"}>}RowTotal)
If I have helped you or answered your question, please remeber to mark the reply as such
Ok so the simplest way is to use:
=Sum({<FiscalYear = {'$(CurrentYear)'}>}RowTotal)
But whack an = on the start of your variable definition
=Max(Right(FiscalYear,4)) -1 & '-' & Max(Right(FiscalYear,4))
If I have helped you or answered your question, please remeber to mark the reply as such
Can you try one of these:
Sum({<FiscalYear = {'$(=$(CurrentYear))'}>}RowTotal)
Sum({<FiscalYear = {'$(=(LastYear))'}>}RowTotal)
or
Sum({<FiscalYear = {'$(=CurrentYear)'}>}RowTotal)
Sum({<FiscalYear = {'$(=LastYear)'}>}RowTotal)
Thanks, it worked.
Hi Sunny,
While using the all the three measures in same "LineChart", in Legends System shows
How can I display year number i.e. variable value 2015-2016 .... 2014-2015 ... 2014-2013 in Chart Legends ?
Can you please guide!