+ Start a Discussion

merge field in formula not showing enough decimal places

I have a number field that I am referring to in formula field via a merge field. The field has 5 significant digits. However, the formula field is only using 3 digits when merging.



 The above field has 5 decimal places of information eg. -85.57575


but the formula only merges the value: -85.576. For some reason, it is rounding it when I never asked it to.


What can I do?


Did you mention/ define the percision of the formula field as you were creating the formula field?

If no then then please do specify the decimal places of the formula field as 5 then I think the issue should be resolved.


Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.



The level of precision was already defined as 5. However, the formula only produces 3. What gives?