Expand my Community achievements bar.

SOLVED

rounding up to nearest (5) days

Avatar

Level 5

I have a field that shows the total # of actual days and I want to create a field that will take that # and round it up to the nearest 5 days.  

 

Example 1:  total actual working days = 18; total days = 20

Example 2:  total actual working days = 24; total days = 25

 

How can I do that?  Here is my file

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@ReluctantProgrammer :

 

You can use below JS method to get it done.

 

Math.ceil(total actual working days / 5) * 5;

E.g:

Math.ceil(18 / 5) * 5;
20

Thanks,
Siva

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

@ReluctantProgrammer :

 

You can use below JS method to get it done.

 

Math.ceil(total actual working days / 5) * 5;

E.g:

Math.ceil(18 / 5) * 5;
20

Thanks,
Siva