Background:

The field 'FORECASTDEMANDCOST' is coming from the master file WEBFOCUS_FULL_INFO

FIELDNAME=FORECASTDEMANDCOST, ALIAS=ForeCastDemandCost, USAGE=A254V, ACTUAL=A254V,
MISSING=ON, $


The second field that is of concern is calculated as follows:
TABLE FILE SPR_CURR
PRINT
CUR_RATE
WHERE CUR EQ '&CURR';
ON TABLE SAVE AS CURR1
END
-RUN
-READ CURR1 &CURR1.A20

I then have a define where I do the following:
DEFINE FILE ITDEMANDSHOLD
DFORECASTDEMANDCOST/D12.2 = FORECASTDEMANDCOST/&CURR1;
END

TABLE FILE ITDEMANDSHOLD
PRINT DDEMANDID
DFORECASTDEMANDCOST
END
-EXIT


The problem is with the formats. But I dont know how to fix this...Can you please suggest what is it that I should do?

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

Shubha,

My first thought would be to convert the FORECASTDEMANDCOST field to a numeric field using the ATODBL function.

You are trying to do a calculation with alpha fields.

Is there à relation between the forcastvalue and the currency code?
Is there a time relation ?