Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [solved]How to show 0 before decimal when the data is LT 1
Go
New
Search
Notify
Tools
Reply
  
[solved]How to show 0 before decimal when the data is LT 1
 Login/Join
 
Member
posted
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,
 
Posts: 10 | Registered: September 05, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2365 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
It worked perfectly! Thanks a lot MartinSmiler
 
Posts: 10 | Registered: September 05, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2365 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
It is doneSmiler
 
Posts: 10 | Registered: September 05, 2018Reply With QuoteReport This Post
Member
posted Hide Post
DoneSmiler
 
Posts: 10 | Registered: September 05, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [solved]How to show 0 before decimal when the data is LT 1

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.