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!

Ying

This message has been edited. Last edited by: YY,

SET CENT-ZERO = ON

It worked perfectly! Thanks a lot Martin

My pleasure

Please edit your first post then into the subject add [SOLVED] at the beginning.

It is done

Done