SAP Analytics Cloud Devide Zero Error

[wolfgang_runge]

Dear Community,

it seems that since a while tabels are showing DIV0_ERR when the value to be devided is zero. I found a release note in 2021.14 that SAC is now following Excel guidelines (if this is the right approach is a question).

Fact is that all tables of our customer are now showing DIV0_ERR. Before the tables showed zero / blank.

Has anybody an idea how we could overcome that? Of course you could use an if-statement but then we need to change a lot of stories and tables. This cannot be the goal of SAP.

Thanks for your help!

Best regards,

Wolfgang

[VijayetaSharma · Accepted solution]

Hello wolfgang.runge,

Only way to suppress these error messages is via "If" statement for now.

There are no enhancement request available to "Suppress system messages and errors". Might be a good idea to create one.

SAP Influence Council

Thanks,

Vijayeta

[runu · Accepted solution]

Hi Vijayeta,

This only workes when there is actually a value in the cell.

But as the screenshot of Wolfgang shows, the fields in 2020 are empty. In that case If does not work.

Is there any other solution you could provide?

Kind regards

Ruth

[prachi_pawaskar]

Yes , we are also facing the same error in many reports.

Wish we had SAC to accept all the excel functionalities in SAP SAC, or have an addin for SAP SAC which can be integrated with Excel and have all the functions such as EPM functions / EVDRE functions enabled along with standard Excel functions like , drop downs, Vlookups, VBA , and other functions which can be easily integrated at reporting level of SAP and some more functionalities like sub totals and colour coding in SAC like EPMexcel formatting in SAC would be a great feature in SAC stories

[wolfgang_runge]

Thank you very much!

I can't believe that SAP is turning this into something which is much worse and which needs a lot of effort to modify existing tabels.

Best regards,

Wolfgang

[wolfgang_runge]

Here the screen.