Ignore blank dates for MIN calculations

helennie

I'd like Anaplan to ignore blank dates when performing MIN calculations: MIN, x[MIN:y], and MIN as a summary function.

 

For numbers, I can see why 0 is evaluated since sometimes those are true zeroes, but for dates this makes much less sense. With dates, I would want the MIN calculations to return blank only if all of the items are blank or do not exist.

alexpavel

Indeed it would be useful to have the possibility to ignore "blanks" or "zeros" for MIN functions adding a parameter to the function/summary method. 

 

Thanks

Alex

 

Miran

Status changed to: In Review

EarlC

This bug/feature request is part of a generalized issue with how Anaplan does not distinguish between null vs zero values.  This also shows up in treating nulls as zeros in all aggregation functions--I'm thinking of Average specifically.  I'd encourage that this be fixed for ALL aggregations, not just MIN.

Gwen.pryor

Status changed to: In Review

JP

Especially in combination with Gantt charts, this is important to better understand aggregated start dates, and it should be optional.