WAD Input Field with two decimal places required

[Former Member]

Hi,

I have an Input Field in a WAD template where the planners are to enter a discount rate with two decimal places. This entry is then to be copied to all fields in the planning layout by using an IP Fox Formula.

When the planner enters a rate of say 103.75 in the Input Field and hits a COPY button, only the value of $104 is copied to the Info Cube. The IP FOX planning function passes the value in the Input Field to a BW Formula Variable.

In the WAD I had to turn off the numeric check box in the Input Field to get the Input Field to accept a value with 2 decimals.

For the BW Formula variable I have tried using types: Numeric, Amount and Price.

The Key Figure is a standard SAP one of type Amount and has other postings with 2 decimal places.

Regards,

Tony

[cornelia_lezoch · Accepted solution]

Hi Tony,

I am not sure what you mean by: "For the BW Formula variable I have tried using types: Numeric, Amount and Price."

I define my variables either type I (Integer) or type F (floating point). In your cas floating point would be the right choice.

regards

Cornelia

[Former Member · Accepted solution]

Thanks Cornelia.

My FOX had the statements:

DATA RATE TYPE I.

RATE = VARV(ZRATE).

When I changed it to TYPE F it works. Thanks again.