Products | Versions |
---|---|
ibi WebFOCUS | 9.1.2 |
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:
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.
Note: Issue does not occur if you set the calculation to divide by a value (Example: Calculation_1/5 ; or Calculation_1 * 3)
Resolution:
Change 2 of the DEFINEs to COMPUTEs and the calculations appear correct with those changes.
Please check the below images for the difference.