Highlighted
Occasional Contributor

importing the same day's data

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.PNGAnaplan.PNG結果.PNG

2 REPLIES 2
Certified Master Anaplanner

Re: importing the same day's data

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.

Occasional Contributor

Re: importing the same day's data

Thank you so much!!
It's helpful.