Aggr function to find Min Max values not working

[#1]

Hi,

I'm trying to put a table chart for each product id, similar statistics box.

Attached sample data that is similar to my scenario, not successful in finding Min and Max values. Somecases, Max value is worked but not Min value as it considers null or zero values.
Appreciate your help.

Regards,

Laks

[swuehl · Accepted solution]

Maybe like attached?

Price is value/qty , right?

I just used min(value/qty) resp. max(value/qty) as expressions.

Hope this helps,

Stefan