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