Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script Logic - Divide by zero

Hello,

I'm currently working with SAP BPC NW 10.1 SP5.

I'm trying to create a script logic to determine the value of an account based on a sum and a division of another accounts. When I test this, if the denominator of the division is 0 or non-existing, the whole result is 0, despite the value of the account I'm using in the sum.

Only for testing purposes, I tried to use values instead of accounts, for example:

*REC(ACCOUNT=PESO_PRODUCAO_DIST_M, EXPRESSION=1 + (2/0)  )

If I use this, I expected the result to be 1, but it is zero.

*REC(ACCOUNT=PESO_PRODUCAO_DIST_M, EXPRESSION=1 + 2 )

If I use this, the result is 3 as expected.

Is this any special behavior regarding division by zero? Are there any workaround, without having to use the conditional logic?

Thanks!

Former Member
Not what you were looking for? View more on this topic or Ask a question