DIV0_ERR in Reporting

[PH4]

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

[N1kh1l · Accepted solution]

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

[Feldbinder · Accepted solution]

Hi nikhil_1486,

how would you combine both checks?

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

Best regards

Jörg

[N1kh1l · Accepted solution]

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

[Feldbinder · Accepted solution]

perfect! Thank you.