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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
That's what I needed. Thanks!!