4 Replies Latest reply: Nov 2, 2017 2:07 AM by Ishan Bansal RSS

    Clarification on the query

    Ishan Bansal

      Hi Experts ,


      I have a query which should fetch results based on certain condition for the given year.

      IF(STATUS = 'Closed',COUNT(DISTINCT{<YR={'$(=max(YR))'}>}ID))


      But this query is not fetching any result. can you please help me fix the query.