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

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
  • 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!!!

Children
No Data