Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
This conversation has been locked due to inactivity. Please create a new post.
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.
@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
View solution in original post
That's what I needed. Thanks!!
Views
Likes
Replies