Blank Cell with History

tingtingxia
Contributor

Re: Blank Cell with History

Hi Mark

 

May I understand from you:

1.what is used as your dropdown for End Month selection?

2. the selection is modified by user input or some kind of update action?

 

From my end, I tried to replicate a 3-dimensional module with end month formatted as Period Month, and the history records reconcile with whatever I have changed.

Module:

Screenshot 2021-06-01 at 10.36.01 AM.png

Cell history:

Screenshot 2021-06-01 at 10.35.41 AM.png

End result:

Screenshot 2021-06-01 at 10.40.02 AM.png

 

BR,

Tingting

markturkenburgAesop
Occasional Contributor

Re: Blank Cell with History

Hi @tingtingxia 

 

Thanks for the quick reply

 

The line item is a list formatted (Time Period - Month) line item & by all logic the data that is showing in the history should be displaying in the cell

 

I agree with your logic & that is the way it works 99.9% of the time

 

Mark

ChrisHeathcote
Community Boss

Re: Blank Cell with History

@markturkenburgAesop 

Try investigating the cell history of the cell rather than the model history.

This is should reveal exactly what has been going on in that specific cell of the model.

I dont think this is a platform error but a simple case of the data being deleted from the cell. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
markturkenburgAesop
Occasional Contributor

Re: Blank Cell with History

Hi @ChrisHeathcote 

 

Thanks but that was my 1st point of call (if you review my 1st post). The cell history has no deletion history & but the cell has no value

 

Anaplan support team are currently unable to solve for this

 

Thanks

 

Mark

ChrisHeathcote
Community Boss

Re: Blank Cell with History

@markturkenburgAesop 

Of course, I can see that you have already tried this. 

Have you tried changing the pivot so that you can see all the values across of the dimensions?

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
markturkenburgAesop
Occasional Contributor

Re: Blank Cell with History

Hi @ChrisHeathcote 

 

Yes I have done that but my query was the specific intersection between dimensions where the cell history stated data entry but the cell did not display this

 

Thanks

 

ChrisHeathcote
Community Boss

Re: Blank Cell with History

@markturkenburgAesop 

I think the the module and history data is not comparable.

 

ChrisHeathcote_0-1622544416554.png

The grid shows 'Sustainability Coordinator, Communities' and 'Head Office Expenses' in 'Working'  line item.  

 

ChrisHeathcote_1-1622544523778.png

The history shows changes against, 'Sustainability Coordinator, Communities' and 'Head Office Expense' in 'End of Month (if applicable)' line item.

 

The line item is different. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
markturkenburgAesop
Occasional Contributor

Re: Blank Cell with History

Hi @ChrisHeathcote 

 

'Working' is the Version while 'End of Month (if applicable)' is the line item

 

I have taken another screen shot of the cell history with all the dimensions (see attached)

 

Thanks

Screen shot 4.PNG

rob_marshall
Moderator

Re: Blank Cell with History

@markturkenburgAesop 

 

I figured I might as well jump into this party...Let me ask you question, I see you are working with a numbered list, are you sure you are looking at the same intersection of data?  I ask because the "Sustainability Coordinator" might be repeated in the list.

 

Rob

markturkenburgAesop
Occasional Contributor

Re: Blank Cell with History

Hi @rob_marshall 

 

Thanks for the reply

 

Yes I am working with a numbered list & there are possibly multiple list items with the same 'Display Name' but the data I am referring to above & are in the screen shots are from the same list item

 

Mark