Max/Min with aggr function

[nehasaxena]

Hi All,

I am using below expression -

Num(Max(aggr(Sum([Loss Paid Filter])/sum([Written Premium Filter]),LOB,product)),'#,##0.00%')

I am using max function but it is giving me min value.

and with min expression it is giving zero.

Please help me with the correct expression.

Let me know if further details required

Best regards,

Neha

[antoniotiman]

This is because probably You have any Sum(Loss Paid Filter) = 0.

Try to exclude this value

Sum({<[Loss Paid Filter]-={0}>} [Loss Paid Filter])

[nehasaxena]

Thanks all for response and help. Expressions are working fine. Its just that we have zero and that why min aggr always give 0.

Best regards,

Neha