UNABLE TO PARSE THE MAX() CONDITION IN WHERE CLAUSE

[Former Member]

Hi Techies,

I am getting an error message as - "Parse Failed:An Aggregate function is present in the where clause. (UNV0024)"

when I am trying to give max condition in where clause of an object.

well, what I am trying to achieve is I would like to select the reporting Period(let's say A) and that should be based on the maximum value of a column(Let's say B).

and I have given the condition as max(B) in my where clause and I am getting the error message as below..

Please help me on this

I AM WORKING ON BOXI 3.1 .......

[Former Member]

You can't do that and to be honest, you should avoid using where clauses.

Instead of where, look into using a CASE statement for your object select.

[Former Member]

hi Mark,

Tried the same but it did not worked out...

[Former Member]

What syntax did you use and what error did you get?