Focal Point
[CLOSED] Master File - Field * 100

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/863108325

September 08, 2010, 06:31 AM
umun
[CLOSED] Master File - Field * 100
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
September 15, 2010, 09:51 AM
<HarryL>
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 %',$