Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get last 3 months distinct outlet covered in text object.by month wise values showing correct,but i want to display last 3months outlet count.
ex:- when i am selecting Jan month,i want to display Dec,Non,Oct outlent count.
i am using this expression,
=((count({$<YEAR = {$(=only(YEAR) - $(=if(only(MONTH) = 1, 1, 0)))}, MONTH = {$(=month(addmonths(MonthYear, -1)))},ClosingStock={'>0'}>}
distinct IF(AHC_CallDate = MX_DATE, AHCHdr_Outlet_Code))) --------this is for Dec
+
(count({$<YEAR = {$(=only(YEAR) - $(=if(only(MONTH) <= 2, 1, 0)))}, MONTH = {$(=month(addmonths(MonthYear, -2)))},ClosingStock={'>0'}>}
distinct IF(AHC_CallDate = MX_DATE, AHCHdr_Outlet_Code)))------------------this is for Nov
+
(count({$<YEAR = {$(=only(YEAR) - $(=if(only(MONTH) <= 3, 1, 0)))}, MONTH = {$(=month(addmonths(MonthYear, -3)))},ClosingStock={'>0'}>}
distinct IF(AHC_CallDate = MX_DATE, AHCHdr_Outlet_Code))))-----------------this is for Oct
by giving month wise it showing correct values.
can any one having idea about this,pls help me.
reg,
ba
hi,
Try using this Expression:
=count({1<Mon={$(=Month(addMonths(Date#(GetFieldSelections(Begindate),'DD-MM-YYYY'),-1)))}>}outlet_count)
Where begingdate is date and specify its format, Mon is month derrived from begindate
Hi,
Try this expression
=Sum(Aggr(count({$<MONTH=, DateFieldName={'>=$(MonthStart(Max(DateFieldName), -2))<=$(=Max(DateFieldName))}, ClosingStock={'>0'}>} distinct IF(AHC_CallDate = MX_DATE, AHCHdr_Outlet_Code)), MONTH))
Hope it helps you.
Regards,
Jagan.
Hi All,
Thanks for reply,This is not working,can any one know about this solution.Please help me.
Regards,
ba