Question Re: DIV0_ERR in Reporting in Technology Q&A

DIV0_ERR in Reporting

PH4 — Fri, 21 Apr 2023 08:39:05 GMT

Hello experts,

as you can see in the screenshot below, we have a DIV0_ERR. This does not look nice in the reporting. From the following post, we have seen that there is no solution other than the if statement. Is this still the case or has a simple solution been provided here?

https://answers.sap.com/questions/13501650/sap-analytics-cloud-devide-zero-error.html

Thanks and best regards,

patric

Re: DIV0_ERR in Reporting

N1kh1l — Fri, 21 Apr 2023 17:02:07 GMT

p123

You can just enclose your generated SAC formula for % within a IF block and it should fix this. I have answered this in your other question already.

To avoid the DIV/ERROR error you can change the SAC generated formula like below.

enable the formula bar

Then change the formula as below, just put an IF with check for 0

If its empty values you can check for NULL

Output:

Hope this helps !!

Nikhil

Re: DIV0_ERR in Reporting

Feldbinder — Tue, 01 Aug 2023 05:27:10 GMT

Hi nikhil_1486,

how would you combine both checks?

the check with or (OR; ||) leads to an syntax error.

Best regards

Jörg

Re: DIV0_ERR in Reporting

N1kh1l — Tue, 01 Aug 2023 06:20:30 GMT

feldbinderj

Its a limitation in the formula that you cannot use OR/AND. You can use the below work around.

Hope this helps!!

Please upvote if this helps

Nikhil

Re: DIV0_ERR in Reporting

Feldbinder — Tue, 01 Aug 2023 17:09:47 GMT

perfect! Thank you.