Why does MIN value from an AGGR expression return a 0 when no value are equal to zero

[rviel_dubo]

Hi everyone,

I've got an aggr function that should return the maximum and minimum number of order managed per month for the last 24 months.

The max works fine (19510) but the minimum returns 0, see example below.

I'm getting gray hair over this so please any suggestions will help! 🙂

Thanks,

Robert V.

[lironbaram]

hi

first thing to check is that in your table properties 

under presentation tab you uncheck the option suppress zero values 

usually i'll assume you have some values that are assigned to null month , so you don't see it in the table 

[rviel_dubo]

Hi Lironbaram,

That's the first thing I've looked and that's why I've place a picture of my table along with my request, option is already unchecked and I've got 24 results (24 months rolling). that's why I've having gray hair over this.

Thanks anyway 🙂

[sunny_talwar · Accepted solution]

How about this?

Min({<Sales_MonthSEQ = {">-25<0"}>}
  Aggr(
    Count({<Sales_MonthSEQ = {">-25<0"}>} DISTINCT OrderNo)
  , Sales_MonthName)
)

[rviel_dubo]

No results, 😞

[sunny_talwar]

Not even showing a 0? Any error messages? Can you show an image of the expression in the expression editor?

[rviel_dubo]

[sunny_talwar]

This looks like the original expression you had which was showing 0

Did you try my suggestion?

Min({<Sales_MonthSEQ = {">-25<0"}>}
  Aggr(
    Count({<Sales_MonthSEQ = {">-25<0"}>} DISTINCT OrderNo)
  , Sales_MonthName)
)

Please note that I had a typo on Sales_MonthName field... I have fixed it now... I initially used Sales_Monthname... with a lower case n

[rviel_dubo]

I've just corrected your typo and it works !!!!
Thanks I really appreciate 🙂

[rviel_dubo]

Now if I may ask WHY do I need the extra set analysis before the aggr for the min function and not for the max?