Script Logic - Divide by zero
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?