cancel
Showing results for 
Search instead for 
Did you mean: 

DIV0_ERR in Reporting

PH4
Explorer

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

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

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
Explorer
0 Kudos

Hi nikhil_1486,

how would you combine both checks?

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

Best regards

Jörg

N1kh1l
Active Contributor

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
Explorer
0 Kudos

perfect! Thank you.

Answers (0)