3 Replies Latest reply: Jan 4, 2011 1:12 PM by Sathish G RSS

    Help required in writing a expression.

      Hi All,


      Below expression should work as per the following requirement:

      1. Should be locked for current month for the current year where the values of month in our application is like(m1,m2,...,m12). For your reference, From START_YEAR we are getting the year and from STARTPERIOD we are getting the month(m1,m2,...,m12).

      2. Should be locked for year to date. For your reference, From START_YEAR we are getting the year and from STARTPERIOD we are getting the month(m1,m2,...,m12).



      =ceil(sum(if(wildmatch(Category,'*Callcenter*') > 0 and (wildmatch([Agreement Achieved],'no')>0),1,0)) /


      Hope you can help me out.

      Note: Here month may create the problem as the values of the month are in (m1,m2,...,m12) and it is not like normal month(Jan-Dec) and also finding the max of month from these values (m1,m2,...,m12) is also a concern.

      Thanks in advance. Please let me know once you get to know any solution.