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 thisThis message has been edited. Last edited by: FP Mod Chuck,
April 10, 2018, 08:33 AM
BabakNYC
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.