Skip to Content
avatar image
Former Member

Analysis for Excel 2.3 - blank/null handling

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?

chigo.png (1.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 07, 2017 at 09:42 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded