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