Why does MIN value from an AGGR expression return a 0 but MAX and AVG work? See example

[jblomqvist]

Hi all,

In the example below I get a 0 when I try to get the Min value from an AGGR expression. Max and Avg work so I don't understand why Min doesn't work.

My expressions are:

Max: =Num(Max(Aggr(Sum(LineSalesAmount), SalesPerson)), '#,##0')

Min: =Num(Min(Aggr(Sum(LineSalesAmount), SalesPerson)), '#,##0')

Any ideas please?

[hic · Accepted solution]

You probably have "Suppress Zero-values" checked in the straight table, which hides a salesperson with 0 as sales amount.

HIC

[m_woolf]

Here's a guess:

your straight table has suppress zero values checked.