Previous month count on selected month

[Ramki]

Hi Team,

While comparing the values between  selected month and previous month, the result of previous month showing as 0.

Expression for previous month is: count({<Month={'$(=getfieldselections(AddMonths(Date#(Month))),-1}>} EquipmentID) .

It would be great if any one can suggest me on the expression.

Regards,

Ramki

[NitinK7]

first create variable for year and pre_month

varibales:

vYear=Date(Addmonths(Date#(Max(your date field),'your date field format'),-1),'YYYY')

vPrv_Month=Date(Addmonths(Date#(Max(your date field),'your date field format'),-1),'MMM')

then write below exp

Count({<Year= {$(=vYear)},Month={$(=vPrior_Month)}>}EquipmentID)

[Ramki]

There is no date filed, data loading from excel and  month , year are text fields which are entered manually in the excel.

Regards,

Ramki

[NitinK7]

try below , may be it will work, if not then please attach your excel file for year and month

vYear=Date(Addmonths(Date#(Max(Year),'YYYY'),-1),'YYYY')

vPrv_Month=Date(Addmonths(Date#(Max(Month),'MMM'),-1),'MMM') 

[Ramki]

Hi , 

please close this topic.

Regards,

Ramki