QE-DEF-0459: Parsing Error before or near position

[cognosda]

Ok..seriously..what's wrong with this syntax:

MIN([FM].[Package_name].[date_column_in_fact] FOR [another_column_in_fact])

This is giving me this error:

QE-DEF-0459 CCLException
QE-DEF-0260 Parsing error before or near position: 74 of : MIN([FM].[Package_name].[date_column_in_fact] FOR [another_column_in_fact])
QE-DEF-0261 QFWP -Parsing Text: MIN([FM].[Package_name].[date_column_in_fact] FOR [another_column_in_fact])

Something so straightforward has taken 3 hours of research now.

I am trying to implement : min(date_column_in_fact) over (partition by another_column_in_fact)

[cognosda]

Ok, I need coffee. I was using MIN, whereas the function is MINIMUM. It works now!!!

This is resolved.