Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I write the expression :
SUM({<[Forecast Fiscal Month] = {'$(=([Forecast Fiscal Month],-1))'}>}[Stag Forecast Units])
SUM({<[Forecast Fiscal Month] = {"$(=Max([Forecast Fiscal Month])-1)"}>}[Stag Forecast Units])
It depends on how the data look like in your field [Forecast Fiscal Month], like 'Jan', 'Feb' ..., or 1,2,...? If like 'Jan', ..then,is it created using month() in the script or simply a string represenattion?
Write like
=SUM({<[Forecast Fiscal Month] = {$(=Max([Forecast Fiscal Month])-1)}>} [Stag Forecast Units])
you can use
SUM({<[Forecast Fiscal Month] = {'$(=(Month(Addmonths(Date,-1)))'}>}[Stag Forecast Units]).
for subtracting a month from the date field
himank
The data has to calculated through the period
Jul 2013 Aug 2013 Sep 2013 .......................Jun 2014
Sample : =SUM({<[fis_month] = {$(=Max([Forecast Fiscal Month])-1)}>} [Stag Forecast Units])
is not working...
The data has to calculated through the period
Jul 2013 Aug 2013 Sep 2013 ....................... Jun 2014
Sample : SUM({<[fis_month] = {'$(=(Month(Addmonths(Forecast Fiscal Month,-1)))'}>}[Stag Forecast Units])
is not working...
PFA..
My data looks like that.........
Then, try like:
SUM({<[Forecast Fiscal Month] = {'$(=(MonthName(Addmonths(Date,-1)))'}>}[Stag Forecast Units]).
Update:
Missed the max(). Try=SUM({<[Forecast Fiscal Month] = {'$(=(MonthName(Addmonths(Max([Forecast Fiscal Month]),-1)))'}>}[Stag Forecast Units]).
The data has to calculated through the period
Jul 2013 Aug 2013 Sep 2013 .......................Jun 2014
Sample : =SUM({<[fis_month] = {$(=Max([Forecast Fiscal Month])-1)}>} [Stag Forecast Units])
is not working...
PFA ...My data looks like that......
can you share the sample qvw?