We have a EXL2K FORMULA report output with fields format as D20.2 (Actual field format is D20.6). By default EXL2K FORMULA format rounding off to the nearest integer value and then display it in excel.
Eg,. My field value is 43.376580, but it showing as 43.3766 in excel formula bar.
How to disable/remove this round off in EXL2K FORMULA output...?
I need actual value 43.37658 in cell. How to achieve this..?
Thanks..This message has been edited. Last edited by: Maran,
Try changing the format to P12.6. 1. Actual of 12.6 is not the usage of 12.2 2. Redefine with P12.6 3. Screenshot shows IBI automatically uses ROUND in the formula. 4. Code below works for me.
TABLE FILE CAR
ON TABLE SET PAGE-NUM OFF
SUM RC AND DC AND
COMPUTE PROFIT/P12.6 = (RC - DC) * .43567;
BY CAR
HEADING
"Profit By Car"
" "
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT EXL2K FORMULA
ON TABLE SET STYLE *
TYPE=REPORT, COLOR=BLUE, BACKCOLOR=SILVER, SIZE=9,$
TYPE=HEADING, STYLE=BOLD, SIZE=14, $
TYPE=TITLE, STYLE=BOLD, SIZE=11,$
TYPE=GRANDTOTAL, STYLE=BOLD, SIZE=11,$
ENDSTYLE
END
-EXIT