Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
There is no date filed, data loading from excel and month , year are text fields which are entered manually in the excel.
Regards,
Ramki
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')
Hi ,
please close this topic.
Regards,
Ramki