Calculated Field Formula to round

I have the calculated field formula: multiply(number($roofs_completed_yearly_c),number($malarkey_roofs_yearly_c)) The field is an integer so I need to round the result to avoid error. How can I write the formula to round the result?

Parents

0 Jeff Bickart over 1 year ago

Kate Rose; there are the following functions, ceil, floor, and round. The guide can be found at support.sugarcrm.com/.../index.html
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kate Rose over 1 year ago in reply to Jeff Bickart

Thank you! I hadn't thought to try ceil - and knew I was missing something. started the formula there and it did what I needed. Thank you again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kate Rose over 1 year ago in reply to Jeff Bickart

Thank you! I hadn't thought to try ceil - and knew I was missing something. started the formula there and it did what I needed. Thank you again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data