Expression for previous month

[#1]

  I need the expression for previous month using set analysis............ I have the expression for it which is MonthName(AddMonths(Today(),-1)) but i need it in set analysis..........thnx in advance.........

[CELAMBARASAN]

Hi,

     Use as it is

     Sum({<MonthYearFieldName={'$(= MonthName(AddMonths(Today(),-1)))'}>} Sales)

     MonthYearFieldName is the Field you created using MonthName function in the load script.

Celambarasan

[Anonymous]

Hi

     Hope the following attached file will be helpful for your problem

Regards

Ashok

[#4]

Thanx for reply Celam........... I m using this expression for fetching the data for previous month...........but it is not giving the result............so i thought to use set analysis............. The expression is   if(MonthName(AddMonths(Today(),-1))=TIME_FRAME.TIME_FROM,RULES_SPECIAL.FACTOR_VALUE)............Can u suggest me something on this..............

[CELAMBARASAN]

Hi,

     The expression should be

     Sum({<TIME_FRAME.TIME_FROM={'$(=MonthName(AddMonths(Today(),-1)))'}>} RULES_SPECIAL.FACTOR_VALUE)

Before that What type data in the TIME_FRAME.TIME_FROM field?

Celambarasan

[#6]

thanx for reply........ TIME_FRAME.TIME_FROM  is date in format mm/dd/yyyy............

[#7]

the above expression is not working.......... I need to just show the data related the previous month............

[CELAMBARASAN]

Hi,

     Try with this

     Sum({<TIME_FRAME.TIME_FROM={">=$(=MonthStart(Today(),-1))<=$(=MonthEnd(Today(),-1))'}>} RULES_SPECIAL.FACTOR_VALUE)

Celambarasan

[#9]

Hi celam..........

the RULES_SPECIAL.FACTOR_VALUE  contains Factor: 0.2 types entities.........i can't use SUM there.........so suggest something beside from sum...............thanx for reply

[CELAMBARASAN]

Hi,

     Ok then you have to try with

     MaxString,MinString,Only,Concat functions

     Use this

     =MaxString({<TIME_FRAME.TIME_FROM={">=$(=MonthStart(Today(),-1))<=$(=MonthEnd(Today(),-1))'}>} RULES_SPECIAL.FACTOR_VALUE)

Celambarasan