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?
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?
Hi Kate Rose,
Can you clarify how you want the result rounded (e.g. rounded to the nearest integer, always rounded up to the nearest integer, etc.)? Are both of the fields in your multiply calculation integers as well?
Chris
I'd like it rounded up to the nearest integer. roofs_completed_yearly_c is an integer, malarkey_roofs_yearly_c is a drop down list with percentages ranging from 0-100 in increments of 10
Kate Rose; there are the following functions, ceil, floor, and round. The guide can be found at support.sugarcrm.com/.../index.html
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.