Register

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.

5 Comments
alexpavel
Certified Master Anaplanner

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
Community Manager
 
Status changed to: Your support is needed
EarlC
Contributor

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
Regular Contributor
 
Status changed to: Under Investigation
JP
Occasional Contributor
Occasional Contributor

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

New Solutions
Anaplan Platform
DMManalili
Frequent Contributor