[solved]How to show 0 before decimal when the data is LT 1
Hello,
I am new to Webfocus. Does anyone know how to show the "0" before decimal places? I was calculation the YOY increase in percentage and got .31% but I'd like to show it as 0.31%.
TABLE FILE R1 SUM R1.R1.CY_REV/D18.2CM NOPRINT R1.R1.LY_REV/D18.2CM NOPRINT COMPUTE YOYA/D18.2% MISSING ON = IF R1.R1.LY_REV EQ 0 THEN MISSING ELSE IF R1.R1.CY_REV EQ 0 THEN -100 ELSE ((R1.R1.CY_REV / R1.R1.LY_REV)-1)*100;
This is the data format I was using (D18.2%).
Thanks in advance!
YingThis message has been edited. Last edited by: YY,
November 07, 2018, 11:22 AM
MartinY
SET CENT-ZERO = ON
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
November 07, 2018, 11:53 AM
YY
It worked perfectly! Thanks a lot Martin
November 07, 2018, 11:57 AM
MartinY
My pleasure
Please edit your first post then into the subject add [SOLVED] at the beginning.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007