Ignore blank dates for MIN calculations

Ignore blank dates for MIN calculations

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.

Master Anaplanner/Community Boss

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. 





Community Manager
Status changed to: Your support is needed

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.

Regular Contributor
Status changed to: Under Investigation
Users Online
Currently online: 161 members 519 guests
Please welcome our newest community members: