Hi all,
I am trying to convert my currencies to ZAR using CURRENCY_CONVERT. Here is my code:
CURRENCY_CONVERT ("o_celonis_SalesOrderItem"."NetAmount", FROM ( "o_celonis_SalesOrderItem"."Currency" ), TO ('ZAR'),
"o_celonis_SalesOrderItem"."CreationTime" ,"o_celonis_CurrencyConversion", "o_celonis_CurrencyConversion"."ExchangeRateType"
, "o_celonis_CurrencyConversion"."SourceSystemInstance" )
But it does not work.