Dipslay zero instead of "-" symbol in Excel report in SAP Analytics Cloud, add-in for Office

[Former Member]

Dears,

is it possible to display the number 0 instead of the "-" symbol in the Excel report with in SAP Analytics Cloud, add-in for Microsoft Office?

Thanks in advance!

Regards,

Andrea

[JohnL]

Hi Former Member ,

Those are called unbooked values (different than 0).

I don't believe you can change that feature. Have you already searched here?:

SAP Analytics Cloud, add-in for Microsoft Office - SAP Help Portal

jeanne.bigonnet , do you know?

Thanks,

John

[alexander_peter · Accepted solution]

Hi all,

you cannot change this.

But I admit in Excel you would like to use formulas that relate to these cells that are NULL ... and you would expect to calculate this as 0 .... we'll check what we can do here.

Best,

Alex

[AnnaBurkhardt · Accepted solution]

Hi Former Member

if this answer resolves your question please accept it so it can be found more easily by other community members.

Best

Anna

[bigonnet]

Dear all ,

yes, we do plan to release a new handling of "unbooked cells " which will allow you use formulas that relate to these NULL cells . The "-" will still be visible in the grid but in reality the cell will contain "0"( not visible) , where you will be able to relate formulas.

This is planned to be released by the end this month - of course if we are not facing any unexpected issue .

Best

Jeanne

[Ensar]

What happened with the planned release? SAC Add-in is still showing "-" for unbooked cells and formulas can still not be used due to that

Thanks