This discussion is archived
3 Replies Latest reply: Nov 14, 2012 8:29 AM by vjbez1 RSS

Filter Function

vjbez1 Journeyer
Currently Being Moderated
Hi

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points