Can anyone help me to convert currency? We have editable currency fields called "Annual Maintenance Cost" and "Annual Maintenance Cost (Ref). When a user update the "Annual Maintenance Cost" with their currency, I'd like to know the amount in JPY. I configured one business rule below. However, it seems not working. I expected "JPY; 110,000,000" for "USD; 1,000,000" but the return value was "JPY; 9,090.9091" as shown in the attachment.
# Business Rule
- Timing
Before Update or Insert
- Code
(function executeRule(current, previous /*null when async*/) {
var value = parseFloat(current.u_maintenance.getReferenceValue());
current.u_is_related = current.u_is_related.getReferenceCurrencyCode() + ';' + value;
})(current, previous);
