Hi All,

I am uploading the excel via direct retrieval which just have two columns , one is Company and other is a cost in decimal places.

Below is content of excel.

Company Cost
ABC 422.56
PQR 12.5
XYZ 7000.67

I created synonym for the sheet which creates below master file.

FILENAME=COSTSHEET, SUFFIX=DIREXCEL,
DATASET=E:\WEBFOCUS\ibi\apps\baseapp\Book1.xlsx, $
SEGMENT=COSTSHEET, SEGTYPE=S0, $
FIELDNAME=COMPANY, ALIAS=Company, USAGE=A3V, ACTUAL=A3V,
MISSING=ON,
TITLE='Company', $
FIELDNAME=COST, ALIAS=Cost, USAGE=A13, ACTUAL=A13,
MISSING=ON,
TITLE='Cost', $

When I create a report on top of this master file it doesn't show me the decimal numbers.

I tried editing the master file with diffrent types like P13.2, D9.2 etc but it doesnt work for me.

It either adds the decimal point to actual number or prefix two digit befor the acutal numbers .

Below are some of my outputs .Which shows the wrong cost.

with USAGE=A13, ACTUAL=A13,
Company Cost
ABC 42256
PQR 125
XYZ 700067

with USAGE=D9.2, ACTUAL=A13,
Company Cost
ABC 42,256.00
PQR 125.00
XYZ 700,067.00


with USAGE=P13.2, ACTUAL=A13,
Company Cost
ABC 42256.00
PQR 125.00
XYZ 700067.00

I am using below version.
Gen Number858 & Release81M

Can you please help me the solution or any workaround for this

This message has been edited. Last edited by: FP Mod Chuck,

Can you edit the Excel file and change the format of the Cost column to Numeric? Then upload again and recreate the synonym. If you're getting an A13 Format and Actual, WebFOCUS thinks it's reading a string.