Need Help to write the expression.

[suvechha_b]

How can I write the expression :

SUM({<[Forecast Fiscal Month] = {'$(=([Forecast Fiscal Month],-1))'}>}[Stag Forecast Units])

[MK_QSL]

SUM({<[Forecast Fiscal Month] = {"$(=Max([Forecast Fiscal Month])-1)"}>}[Stag Forecast Units])

[tresesco]

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?

[its_anandrjs]

Write like

=SUM({<[Forecast Fiscal Month] = {$(=Max([Forecast Fiscal Month])-1)}>} [Stag Forecast Units])

[#5]

you can use

SUM({<[Forecast Fiscal Month] = {'$(=(Month(Addmonths(Date,-1)))'}>}[Stag Forecast Units]).

for subtracting a month from the date field

himank

[suvechha_b]

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...

[suvechha_b]

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.........

[tresesco]

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]).

[suvechha_b]

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......

[#10]

can you share the sample qvw?