Analysis for Excel 2.3 - blank/null handling

[former_member245931]

Hi Team,

We are getting a issue while handling Null/Blank values in Analysis office 2.3.

When a Key value has Null - its displaying as # and the text is displayed as "NOT_ASSIGNED"

When a key value has Blank - its displayed as ##.

Screen shot from AO 2.3

Screen shot from HANA View

Is there a way we can suppress?

[Former Member]

Hi,

I know this topic is a bit aged, but I would like to continue this thread because I am facing a similar issue.

In the Bex version of planning I could paste a complete line, once the date was saved all empty characteristics were shown with a "#".

However in the Analysis Office side, when I create a new member I am forced to put manually the "#" in those cells I don't have a default value. Did anybody struggled with this issue. For a single line there is Ok, but when the user needs to created several lines is a pain. I could build a kind of VBA code to complete this information, but I would preffer this option as final scenario.

Thanks in advance.