limit data by expression does not work when combine with OVER

Hi,

i am using limit data by expression and Over function at the same time. i want to calculate the lowest rank group by schema_name. However its not functioning as i would imagine.

iam using Min([Rank]) over ([SCHEMA_NAME])

Attachments

AttachmentSize
Binary Data book1.dxp46.02 KB
Image icon untitled.png6.54 KB

1 Comment

Can you provide your dxp with the data embedded? Also, can you clarify what you are trying to calculate in a bit more detail, perhaps with an example?

Sean Riley - Feb 02, 2017 - 2:04pm
+ Add a Comment
Login