Problem with division as output is either 0 or 1 when using ifthenelse condition in ABAP program

The problem occurs when using the ifthenelse condition in ABAP programs for division operations. The issue is that your second parameter is 0 which is an integer, so the output always comes as an integer as ifthenelse takes its data type from the second parameter.

In your case, if the division result is less than 0.5, it gets converted to 0, and if it's more than 0.5, it gets converted to 1. This happens because ABAP performs implicit type conversion based on the data type of the second parameter in the ifthenelse function.

Solution

To resolve this issue, you need to use a cast operation for the second parameter to convert it to decimal data type. This ensures that the entire expression maintains decimal precision ?

ifthenelse(Query.Den = 0, cast(0, 'Decimal(16, 02)'), Query.Num / Query.Den)

Explanation

The cast(0, 'Decimal(16, 02)') function converts the integer value 0 to a decimal type with 16 total digits and 2 decimal places. This forces the ifthenelse function to return decimal values instead of integers, preserving the precision of your division operation.

The parameters in the decimal cast are ?

• 16 ? Total number of digits (precision)
• 02 ? Number of decimal places (scale)

Alternative Approach

You can also cast both parameters to ensure consistency ?

ifthenelse(Query.Den = 0, cast(0.00, 'Decimal(16, 02)'), cast(Query.Num / Query.Den, 'Decimal(16, 02)'))

Conclusion

By using the cast function to convert the integer parameter to decimal type, you ensure that division operations in ABAP ifthenelse conditions maintain their decimal precision instead of being truncated to integer values.