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     [CLOSED] Master File - Field * 100
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Master File - Field * 100
 Login/Join
 
Platinum Member
posted
I have a reporting object (Infoassist report) that makes use of a master file using cube data. One of the fields returns a percentage value.

Here is the master file definition of the field:

FIELDNAME=NET_LOSS_RATIO, ALIAS='Net_Loss %', USAGE=D21.2%, ACTUAL=D8,
MISSING=ON,
TITLE='Net Loss %',
PROPERTY=MEASURE, $

When the report is accessed directly or via infoassit, the value I am getting needs to be multiplied by 100. I am getting 0.01, 0.05, 0.50 etc. But I will like to be able to multiply it by 100 at the master file level so that the value now becomes 1%, 5& and 50% respectively.

I have tried using define or compute, but the original field is still showing.

Any assistance will be appreciated. Thanks.

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


WebFOCUS 7.7.02
Windows/SQL/CUBES
HTML/PDF/XLS
 
Posts: 117 | Registered: November 18, 2009Reply With QuoteReport This Post
<HarryL>
posted
Try this: Rename the original field and use the
original fieldname in the define. e.g.
FIELDNAME=XNET_LOSS_RATIO, ALIAS='Net_Loss %', USAGE=D21.2%, ACTUAL=D8,
MISSING=ON,
TITLE='Net Loss %',
PROPERTY=MEASURE, $
DEFINE NET_LOSS_RATIO = XNET_LOSS_RATIO * 100;,
TITLE='Net Loss %',$
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Master File - Field * 100

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