Please find the below front end expression & let me know, how to optimize this or provide me better way. This is taking longer time to load application & some time error occurred (expression tome out).
Purpose of this --- when I selecting the one date , I want to take the items of Year to last Month end date (YTLM) average sales <=100 (Exclude month no 9 & 12 sales).
Sorry for the late reply & Thank you very much for your effort, I understood that the difficulty of this. So can you please let me know whether I can extract Last 12 months data when selecting the particular date?
As correctly write @felipedl it`s difficult to work with this formula without application model, but i have some advices, that may help you.
# 1. How YEAR, MONTH and QUARTERNO related to TRANSDATE in data? Did you use master calendar for dates? If yes, may be you need to filter only TRANSDATE field and comment filters of YEAR, MONTH and QUARTERNO as in the following example:
And using this field may automatically exclude data with months 9 and 12, because it has NULL and not included in set analysis. Of course this advice is not applicable if you configure these months from interface.