Forumla Limitation To 2 Decimal Places?

[dodom2]

Good Morning,

Im using the concatenate feature to auto generate a description for me. However the decimal places isnt limited to 2. Is there a way to limit it in the concatenate formula? Below is my formula.

metaTagDescription = string\concatenate('FINANCING AVAILABLE!!! Get your ',name,' (',manufacturerPN,') made in the USA by ', brandName ,' for as little as $', listPrice, '!!!');

[esforim]

Hi dodom2, can't help you cause I'm new to this. How do you use the concatenate feature? There was two field (e.g LAST NAME, First Name - Mobile Phone) that I wanted to do this but failed to and broke my EspoCRM at one point. Would appreciate some guidance.

Did you know of an easier way or you did the same way as eymen.elkum did?
Here was my failure thread: https://forum.espocrm.com/forum/gene...te-concatenate

---

Edit: Figure out how to do it. See this thread here:

https://forum.espocrm.com/forum/general/56340-formula-calculation-not-working

[Maximus]

Hi Dustin,
Perhaps you have to use this formula condition:

number\format(VALUE, [DECIMALS], [DECIMAL_MARK], [THOUSAND_SEPARATOR]).

.
Read more about it here https://github.com/espocrm/documenta...d#numberformat.