Date Line Item using Min Summary

Hello

I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same.

I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding.

Regards

Accepted answers

All comments

mohitohri1811

Hello, Thanks for looking into it, but it doesn't work incase there are no P6 list members. Also, I do not want to hardcode P6 list member & it should apply to wherever P6 members are available. Please advise.

mohitohri1811

Example screenshot below. If there is no L6 member, date automatically comes up as 12/31/2399. I am using a MIN Summary function here.

But incase I have atleast 1 L6 member, it looks good. Please advise.

mohitohri1811

What should be the result incase there is no P6 list member ?

In current scenario, if my p6 member is blank or non blank, all p5 till p1 looks good. However, incase there is no P6 member, all other lists from P5 till P1 shows 12/31/2399 due to Min Summary I am using. Please advise.

unknown

This content has been removed.

seymatas1

Hi Mohit,
I don't know the underlying reason but here is a workaround for your issue:

I hope this helps.

Seyma 🌷🙂

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385