topic Previous month count on selected month in App Development

Previous month count on selected month

Ramki — Tue, 30 Nov 2021 18:17:33 GMT

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 — Thu, 01 Jul 2021 14:13:13 GMT

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 — Thu, 01 Jul 2021 14:40:42 GMT

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 — Thu, 01 Jul 2021 14:59:17 GMT

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 — Fri, 09 Jul 2021 13:12:41 GMT

Hi ,

please close this topic.

Regards,

Ramki