Convert Source and Subsystem Balance into Numeric Without Currency Name attached
SummaryConvert Source and Subsystem Balance into Numeric Without Currency Name attached
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.