Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show Last 3months distinct outlet coverage in text object.For Month-wise outlet count is coming correctly in my application.
Can any one know How to calculate Last 3month distinct outlet coverage.
Regards,
ba
Hi,
Use the expr like this in ur textobject
=sum({<MonthNo={2}>+<MonthNo={3}>+<MonthNo={4}>} DISTINCT Outlet)
Hi,
Use this expression
=Count({<DateFieldName={'>=$(=AddMonths(Max(DateFieldName), -2))<=$(=Max(DateFieldName))'}>} DISTINCT outlet )
In above expression replace DateFieldName with your date field name.
Hope this helps you.
Regards,
Jagan.
Hi Sweth and Jagan,
Thanks for ur reply,
Can u please explain these in detaily.I used this expresion but it is showing some error.
thanks,
regards,
ba