Blank dates should not be taken into account when a line item is date formatted and the summary ****

Description of the enhancement required:

Blank dates should not be taken into account when a line item is date formatted and the summary method is set to "minimum". Anaplan should designate the lowest applicable date when this summary method is chosen

 

An example of the enhancement:

If there are three child nodes under a parent, with dates of 1/1/2018, 2/1/2018, and "blank", Anaplan should show 1/1/2018 as the summary at the parent node when choosing Minimum summary method. Currently, Anaplan shows the "blank" field at the parent node which is not a useful or helpful summary

 

How would it help their business process:

 It is very difficult and misleading for Anaplan to take "blanks" into consideration when summarizing a line item. The client wants to be able to show the lowest Start Date among product groupings within the hierarchy and are not able to do so. They have to use a workaround to show the lowest date by formulaically calculating the lowest dates and excluding "blanks". This would make it much easier to get an idea of when the item begin for each department.

5
5 votes

In Review · Last Updated

Comments

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!