How to remove unwanted 000's in a Calculated Field result?

check this:

https://sugarclub.sugarcrm.com/explore/enterprise-professional/f/enterprise-professional-questions/4612/how-to-remove-decimal-value-from-sugar-formula/22920#22920

Thanks Dmytro - that makes sense - I will just have to try and work out where to put it - twice - inside my formula without breaking it lol...

haha, yes - writing formula sometimes is crazy :))


concat(subStr(toString(divide(number($pr_enquiry_initial_payment),number($pr_enquiry_monthly_payment))),0,subtract(strlen(toString(divide(number($pr_enquiry_initial_payment),number($pr_enquiry_monthly_payment)))),7))
," + ",subStr(toString(subtract(number($pr_enquiry_term),1)),0,subtract(strlen(toString(subtract(number($pr_enquiry_term),1))),7)))

is that work?

adjusted a little bit :)))))

Thanks Dmytro - I'll send it over to my Admin and let you know if it fixes it!

okay - I'm intrigued ))

in addition - I would consider configuring logic hooks in cases when the formula is too complex.

Logic hook won't calc the value until record is saved, but, IMHO, provides much better maintainability in such cases

Just try to zoom in and read this:

Here is how it work in the interface:

in addition - I would consider configuring logic hooks in cases when the formula is too complex.

Logic hook won't calc the value until record is saved, but, IMHO, provides much better maintainability in such cases

Just try to zoom in and read this:

Here is how it work in the interface: