We have a scenario where We have one formula field with the currency return type, Now we are using this field in another Rollup field. Let me share one example We have this value CAD 50.00 (USD 38.76) So these fields are displaying two digits after decimal as we have mentioned but as I mentioned I am using the rollup field and it doesn't ask me about the digits that I have to display. So I have one logic that is working but it is returning me 50.000000000000000000000000000000000000058 this value. Anybody faces anything like this please let me know the reason behind it.

  • Floating point numbers are represented using a binary-based approximation. Many straight-forward decimal values cannot be perfectly represented in this binary form, so there may be a very small difference between the decimal value and the binary value. Often this is "fixed" when the binary value is converted back to a decimal (e.g. when displaying the value), but this doesn't always work. I suspect that's what you are seeing here. Why you cannot explicitly define the number of decimal places to show for a rollup is a decision made by Salesforce that I cannot fathom.
    – Phil W
    Jan 14 at 12:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.