get min out of calc

[#1]

hi com,

i want to get the min price per unit out of this calc

aggr(min(sum(total_price)/sum(amount)),article)

i that right or do i have a mistake in there, cause in my KPI there is no value shown!!

thanks,eric

[mgranillo · Accepted solution]

eric,

Aggr returns a table and a KPI needs a single value.  you need to wrap the aggr in another aggregation function.

Move the min outside the aggr function.

Mike

[sunny_talwar]

Do you have a sample you can share with the output you would expect to see?