next even number

  • Resolved hheyhey568

    (@hheyhey568)


    4 years, 9 months ago

    Hello,

    How to get the next even number ? For example: calculated field result is 10.3 but I want 12 as a result which is next even number.

    regards

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @hheyhey568

    You should pass the number 12 as the second parameter of the CEIL operation, as follows:

    
CEIL(10.3, 12)

    Best regards.

    Thread Starter hheyhey568

    (@hheyhey568)

    but all time calculated field does not give 10.3 as result. So 12 is not fixed. I just want that whatever is the result , it shows the next even number. like if it is 3 then it shows 4 , if it is 7 then it shows 8 , the result of calculated field can be any thing and not 10.3 all the times.

    Plugin Author codepeople

    (@codepeople)

    Hello @hheyhey568

    Uses simply:

    CEIL(x,2)

    where X would be your current equation. For example if your equation is fieldname1+fieldname2, edit it as follows:

    
CEIL(fieldname1+fieldname2,2)

    Best regards.

    Thread Starter hheyhey568

    (@hheyhey568)

    thank you, perfect.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘next even number’ is closed to new replies.