Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert Source and Subsystem Balance into Numeric Without Currency Name attached

edited Jan 20, 2021 2:54PM in Account Reconciliation 3 comments

Summary

Convert Source and Subsystem Balance into Numeric Without Currency Name attached

Content

Dear Team

We have a requirement in ARCS to convert the Source and Subsysystem balance in a normal number without currency name attached.

We have tried to use the TRANSLATE function but in our case, we have loaded multiple currencies at the same time and the requirement is to show without currency attached so it can be helpful for them to directly export to excel and work in excel itself. 

We need any attribute functionality that will convert the balance in numeric form. Kindly Help to resolve the same.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!