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?

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:

It's worked!!  - I am just an end user (though i used to do this relational database stuff in another life 20 years ago) and I have to get other people to change anything for me in the system. I think the logic way you showed would be too complicated to get done, and the data is coming in from a web enquiry creating a new lead - so no  edit and save at this point. BUT - the formula you sent was perfect thank you so much!!!