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,

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 %',$