Details about this thread
  • State Suggested Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 295 subscribers
  • Views 1520 views
  • Users 0 members are here
Related content from around SugarClub

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

Adam Ososki

Hi there

I have painstakingly created a formula for a Calculated field and it's very nearly working...

The Formula is 

concat(toString(divide(number($pr_enquiry_initial_payment),number($pr_enquiry_monthly_payment)))," + ",toString(subtract(number($pr_enquiry_term),1)))
The result I get is: "9.000000 + 47.000000"
What would I need to change in the formula to make it just return "9 + 47" ?
Sorry if it's a stupid question - but I haven't written a formula in 20 years prior to getting this far on this one...
Thanks
Parents Reply Children
  • 0 in reply to Adam Ososki

    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?

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient