3 Replies Latest reply on Nov 14, 2012 4:29 PM by vjbez1

    Filter Function


      I am trying to use the filter function in my Report Filters.

      Below is my SQL statement in the report filter but it throws an error that Filter needs an aggregate measure in the first expression.

      Finance.Date = FILTER(Max(Finance.date) USING ABC."Report Period" = 'Daily" AND DEF."Region"="NA")

      Is there something that I am missing here.

      The requirement is to match the date with the max date using the conditions mentioned above in the filter function.

      Any help will be greatly appreciated.

      Exact Error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 22038] Function FILTER requires at least one measure attribute in its first argument. (HY000)

      Edited by: vjbez1 on Nov 14, 2012 6:34 AM