importing the same day's data

Takamasa

Hi.

I have a question about importing.

I want to import excel data(below) but the days are same.

So I want to import value into Anaplan( -7+7=0 )

After imported, import completed successfully and the value became 0 as I wished.

In Anaplan, the value was 0 because it was conducted (-7+7=0)??

If so, even if I have the same day's value, on Anaplan it can recognize both of them and calculate like-7 +7??

Best regards.

質問_excel.PNG 結果.PNG

Accepted answers

kavinkumar

HI @Takamasa,

Yes, that's the beauty of Anaplan. It will automatically recognize the list members itself and aggregates the value if the file has multiple records with same unique identifier. It is not only applicable to Time dimension, but also to all the custom lists as well.

I hope this helps!!

Regards,

Kavin.

All comments

kavinkumar

HI @Takamasa,

I hope this helps!!

Regards,

Kavin.

Takamasa

Thank you so much!!
It's helpful. 😉

Quick Links

Can you help?

Unanswered questions

How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
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…