Seeing incorrect value when using divideby operator in the designer

Seeing incorrect value when using divideby operator in the designer

book

Article ID: KB0070338

calendar_today

Updated On:

Products Versions
ibi WebFOCUS 9.1.2

Description

When using the divideby property in the calculation section the output is not showing correctly. 

In the below image "calculation4=calculation3/calculation1" logic is applied and the output received is incorrect:

User-added image

Issue is suspected to occur because two same fields are divided in the IF statement. That is there is issue when trying to divide and/or multiply between two DEFINEs

Example: Using the CAR file set Calculation_1 to IF CAR.ORIGIN.COUNTRY EQ 'ENGLAND' THEN CAR.BODY.SALES; and Calculation_3 to IF CAR.ORIGIN.COUNTRY EQ 'JAPAN' THEN CAR.BODY.SALES; Calculation_4 = calculation3/calculation1 would show up as 0. 

User-added image

 

Note: Issue does not occur if you set the calculation to divide by a value (Example: Calculation_1/5 ; or Calculation_1 * 3)

 

Issue/Introduction

When using the divideby operator in the calculation section incorrect values are seen.

Environment

Linux

Resolution

Resolution:

Change 2 of the DEFINEs to COMPUTEs and the calculations appear correct with those changes.

Please check the below images for the difference.

User-added image