How to remove decimal value from sugar formula

Hello Everyone,

I applied below formula in my field,

concat("Project ",related($opportunities_deep_ib_deal_1,"project_name_c"),"-",toString(add(related($opportunities_deep_ib_deal_1,"count_of_c"),1))) where "count_of_c" is number type field,

I am getting below value: Project -2.000000

but i want value like: Project -2

How i can achieve this.

Thanks in Advance

Parents

0 Dmytro Chupylka over 3 years ago

subStr($name,0,subtract(strlen($name),7))
where $name is your field with value Project -2.000000

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh over 3 years ago in reply to Dmytro Chupylka

You are treating a number like a string here and assuming that the number will always have 6 decimal places, which could change if anyone changes the precision on the definition of the field, I would respectfully recommend against doing that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Francesca Shiekh over 3 years ago in reply to Dmytro Chupylka

You are treating a number like a string here and assuming that the number will always have 6 decimal places, which could change if anyone changes the precision on the definition of the field, I would respectfully recommend against doing that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Dmytro Chupylka over 3 years ago in reply to Francesca Shiekh

That is an example of how to cut unnecessary text from the string
Also, users do not change precisions for the fields, thought

However, I totally agree that fixing the cause, which seems in the precision set, is the best solution

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel