Calculate differences between categories in currency translation BR

[former_member408921]

Dear experts,

i am trying to calculate the difference between Budget and Actual FX in currency translation BR using "FORMULA" field:

Something like [AVG (BUDGET)] - [AVG (ACTUAL)]

Without using a new Rate Account as i do not want to maintain in Rates model.

Thanks and best

Sebastian

[former_member186338 · Accepted solution]

Sorry, but the mentioned syntax is not supported...

Please read:

https://archive.sap.com/kmuuid2/6052a57b-8c64-2c10-b3a5-b0378ff21243/How%20to%20do%20Currency%20Tran...

You have to perform calculations in script logic!

[former_member408921 · Accepted solution]

Thats a pity. Thanks for the document, i already found a former post of you, Vadim, with this one, but my hope was that something is not mentioned there.

I guess another chance is to maintain another rate account in rates model and calculate the rate there. I can use Standard BR then to calculate with this additional rate.

Nevertheless, thanks and best

Sebastian

[former_member186338 · Accepted solution]

"maintain another rate account in rates model and calculate the rate there" - not clear!

[former_member408921]

Rate Account: Something like AVG - Average rate or CLO - closing rate. I now need the difference of both as a new rate. As both rate i have in rates model already i thought of a simple way to calculate the difference out of the System within the "Formula" field in currency Translation Business rule.

Best

Sebastian