-
Navigate to the Repository Explorer
-
Search and open the view V_INTERNAL_ORDERS Button to create a new view

-
Select the Output Node and click on the Edit button in the Input Parameter section.

-
Add a new Input Parameter with the following properties:
- Business Name: IP_TARGET_CURRENCY
- Technical Name: IP_TARGET_CURRENCY
- Data Type: String
- Length: 3
-
Select the Calculation Node and edit the column NETAMOUNT_TG

-
In the Calculation Expression replace in the CONVERT_CURRENCY() function the 'EUR' with the input parameter :IP_TARGET_CURRENCY

-
Select again the Calculation Node and edit the column TARGET_CURRENCY

-
In the Calculation Expression replace in the constant value 'EUR' with the input parameter :IP_TARGET_CURRENCY

-
Select the _Calculation Node _ and click on the Data Preview button from the context menu

-
In the Input Parameter prompt enter the currency AUD (Australian Dollar)

-
Click on OK button to confirm. Please check the values on the columns NETAMOUNT_TG and TARGET_CURRENCY:

This repository was archived by the owner on Feb 2, 2024. It is now read-only.
