-
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 has been archived by the owner on Feb 2, 2024. It is now read-only.